BOM Tables

Following are the BOM main tables.  bom_bill_of_materials  bom_inventory_components  bom_reference_designators  bom_substitute_components  mtl_item_revisions  bom_operational_routings  bom_operation_sequences  bom_operation_resources  BOM_BILL_OF_MTLS_INTERFACE  BOM_INVENTORY_COMPS_INTERFACE  BOM_REF_DESGS_INTERFACE  BOM_SUB_COMPS_INTERFACE  MTL_ITEM_REVISIONS_INTERFACE  BOM_OP_ROUTINGS_INTERFACE  BOM_OP_SEQUENCES_INTERFACE  BOM_OP_RESOURCES_INTERFACE  MTL_RTG_ITEM_REVS_INTERFACE...

Read More»

FND Concurrent Request Status Codes and Phase codes Meaning

&nbs...

Read More»

SQL Query to find out Parameters and Value Sets associated with a Concurrent Program

SELECT fcpl.user_concurrent_program_name "Concurrent Program Name", fcp.concurrent_program_name "Short Name", fdfcuv.column_seq_num "Column Seq Number", fdfcuv.end_user_column_name "Parameter Name", fdfcuv.form_left_prompt...

Read More»

How to make a Oracle form 'Query Only'

There are many ways in which we can make a form Query only. We are going to discuss two 1) Using parameter QUERY_ONLY=YES 2) using Form Personalization Method 1: Using parameter QUERY_ONLY=YES Lets...

Read More»

Important WF tables

WF_USER_ROLE_ASSIGNMENTS stores information about the direct and inherited assignments of users to roles in Oracle . WF_USER_ROLES stores associations of users with the roles of which they are members. WF_ROLES...

Read More»

R12 SQL Query to differentiate Customer and Suppliers Data

select * from ( select hp.party_number,hp.party_name,hp.status,decode(nvl(hpu.party_usage_code,hp.party_type),'ORGANIZATION','CUSTOMER',nvl(hpu.party_usage_code,hp.party_type)) party_type  from...

Read More»

Important HRMS Tables

per_all_people_f  This table is used to store employee related data. per_all_assignments_f This table store employee assignment related information and connected to per_all_people_f...

Read More»

Sql query for relation between Business Group, Legal Entity, Operating Unit and Balancing segment

select HRL.COUNTRY,  HROUTL_BG.name BG,  HROUTL_BG.ORGANIZATION_ID,  LEP.LEGAL_ENTITY_ID,  LEP.name LEGAL_ENTITY,  HROUTL_OU.name OU_NAME,  HROUTL_OU.ORGANIZATION_ID ORG_ID, ...

Read More»

SQL Query To Check Form Personalizations

SELECT   ffcr.SEQUENCE "Seq", ffcr.description "Description",          DECODE (ffcr.rule_type,                  'F', 'Form',  ...

Read More»

PO Interface Tables

PO_HEADERS_INTERFACE is used to import Purchase Order's Header Level Information PO_LINES_INTERFACE is used to import Purchase order's line level information. PO_DISTRIBUTIONS_INTERFACE is used to...

Read More»

How to Find the Table name on OAF Page

Step 1) Set the profile option "FND: Diagnostics" at User Level to "Yes" set FND : Diagnostics Step 2) Navigate to respective OAF page and Click "About this Page" link at the bottom as...

Read More»