eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_BULKLOAD_PVT_PKG dependencies on MTL_PARAMETERS

Line 189: * organization_id using MTL_PARAMETERS.

185: /********************************************************************
186: * Function : Organization
187: * Returns : NUMBER
188: * Purpose : Will convert the value of organization_code to
189: * organization_id using MTL_PARAMETERS.
190: * If the conversion fails then the function will return
191: * a NULL otherwise will return the org_id.
192: * For an unexpected error function will return a
193: * missing value.

Line 202: FROM Mtl_Parameters

198: l_id NUMBER;
199: BEGIN
200: SELECT Organization_Id
201: INTO l_id
202: FROM Mtl_Parameters
203: WHERE Organization_Code = p_organization;
204:
205: RETURN l_id;
206:

Line 739: AND bsb.Organization_id = (SELECT ORGANIZATION_ID FROM mtl_parameters WHERE ORGANIZATION_code = bmi.ORGANIZATION_code)

735: BMI.Alternate_Bom_Designator IS NOT NULL
736: AND NOT EXISTS
737: (SELECT NULL FROM Bom_structures_b bsb
738: WHERE bsb.Assembly_Item_id IN (SELECT Inventory_item_id FROM mtl_system_items_vl WHERE concatenated_segments = bmi.Item_number)
739: AND bsb.Organization_id = (SELECT ORGANIZATION_ID FROM mtl_parameters WHERE ORGANIZATION_code = bmi.ORGANIZATION_code)
740: AND bsb.Alternate_Bom_Designator IS NULL
741: );
742:
743:

Line 928: l_dyn_sql := l_dyn_sql || ' FROM MTL_PARAMETERS ';

924: l_dyn_sql := 'UPDATE EGO_BULKLOAD_INTF EBI';
925: l_dyn_sql := l_dyn_sql || ' SET INSTANCE_PK2_VALUE = ';
926: l_dyn_sql := l_dyn_sql || ' ( ';
927: l_dyn_sql := l_dyn_sql || ' SELECT ORGANIZATION_ID ';
928: l_dyn_sql := l_dyn_sql || ' FROM MTL_PARAMETERS ';
929: l_dyn_sql := l_dyn_sql || ' WHERE ORGANIZATION_CODE =EBI.'|| G_INTF_ORG_CODE;
930: l_dyn_sql := l_dyn_sql || ' ) ';
931: l_dyn_sql := l_dyn_sql || 'WHERE RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';
932: l_dyn_sql := l_dyn_sql || ' AND PROCESS_STATUS = 1 ';

Line 2629: (SELECT ORGANIZATION_ID FROM mtl_parameters where organization_code = l_usr_attr_data_tbl(i).ORGANIZATION_CODE),

2625: l_str_type_id,
2626: 'SYNC',
2627: l_usr_attr_data_tbl(i).COMPONENT_ITEM_NUMBER,
2628: l_usr_attr_data_tbl(i).ORGANIZATION_CODE,
2629: (SELECT ORGANIZATION_ID FROM mtl_parameters where organization_code = l_usr_attr_data_tbl(i).ORGANIZATION_CODE),
2630: l_usr_attr_data_tbl(i).ASSEMBLY_ITEM_NUMBER,
2631: l_usr_attr_data_tbl(i).PARENT_SOURCE_SYSTEM_REFERENCE,
2632: 70201 -- Added for PIMTELCO Bug-7645265 Hardcoded Value for COMPONENTS_LEVEL data level
2633: );

Line 2648: ORGANIZATION_ID = (SELECT ORGANIZATION_ID FROM mtl_parameters where organization_code = l_usr_attr_data_tbl(i).ORGANIZATION_CODE),

2644: STRUCTURE_TYPE_ID = l_str_type_id,
2645: TRANSACTION_TYPE = 'SYNC',
2646: ITEM_NUMBER = l_usr_attr_data_tbl(i).COMPONENT_ITEM_NUMBER,
2647: ORGANIZATION_CODE = l_usr_attr_data_tbl(i).ORGANIZATION_CODE,
2648: ORGANIZATION_ID = (SELECT ORGANIZATION_ID FROM mtl_parameters where organization_code = l_usr_attr_data_tbl(i).ORGANIZATION_CODE),
2649: ASSEMBLY_ITEM_NUMBER = l_usr_attr_data_tbl(i).ASSEMBLY_ITEM_NUMBER,
2650: PARENT_SOURCE_SYSTEM_REFERENCE = l_usr_attr_data_tbl(i).PARENT_SOURCE_SYSTEM_REFERENCE,
2651: DATA_LEVEL_ID = 70201,
2652: --pnagasur:Added for Bug 13085172