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.EGO_BOM_BULKLOAD_PVT_PKG dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 190: FROM BOM_INVENTORY_COMPS_INTERFACE BICI

186: UPDATE EGO_BULKLOAD_INTF EBI
187: SET EBI.PROCESS_STATUS =
188: (
189: SELECT BICI.PROCESS_FLAG
190: FROM BOM_INVENTORY_COMPS_INTERFACE BICI
191: WHERE BICI.TRANSACTION_ID = EBI.TRANSACTION_ID
192: )
193: WHERE EXISTS
194: (

Line 196: FROM BOM_INVENTORY_COMPS_INTERFACE BICI

192: )
193: WHERE EXISTS
194: (
195: SELECT 'X'
196: FROM BOM_INVENTORY_COMPS_INTERFACE BICI
197: WHERE BICI.TRANSACTION_ID = EBI.TRANSACTION_ID
198: )
199: AND EBI.RESULTFMT_USAGE_ID = p_resultfmt_usage_id;
200:

Line 494: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_INVENTORY_COMPS_INTERFACE ( REQUEST_ID, Transaction_Type, Transaction_Id, Process_Flag, ';

490: -- Header Data Ready
491:
492: -- Process Components for UPDATE
493: l_dyn_sql_insert := '';
494: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_INVENTORY_COMPS_INTERFACE ( REQUEST_ID, Transaction_Type, Transaction_Id, Process_Flag, ';
495: l_dyn_sql_insert := l_dyn_sql_insert || 'ORGANIZATION_CODE, ALTERNATE_BOM_DESIGNATOR, COMPONENT_SEQUENCE_ID, ';
496: l_dyn_sql_select := '';
497: l_dyn_sql_select := l_dyn_sql_select || 'SELECT REQUEST_ID, TRANSACTION_TYPE, Transaction_Id, 1, ' || G_INTF_ORG_CODE || ', ';
498: l_dyn_sql_select := l_dyn_sql_select || 'DECODE(' || G_INTF_STRUCT_NAME || ',Bom_Globals.Retrieve_Message(''BOM'', ''BOM_PRIMARY''),NULL,' || G_INTF_STRUCT_NAME || '), ';

Line 636: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_INVENTORY_COMPS_INTERFACE ( REQUEST_ID, Transaction_Type, Transaction_Id, Process_Flag, ';

632: Dbms_Sql.Close_Cursor(l_cursor_select);
633: -- End of Creating Structure Header record if that is not available.
634:
635: l_dyn_sql_insert := '';
636: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_INVENTORY_COMPS_INTERFACE ( REQUEST_ID, Transaction_Type, Transaction_Id, Process_Flag, ';
637: l_dyn_sql_insert := l_dyn_sql_insert || 'ORGANIZATION_CODE, ALTERNATE_BOM_DESIGNATOR, COMPONENT_SEQUENCE_ID, ';
638: l_dyn_sql_select := '';
639: l_dyn_sql_select := l_dyn_sql_select || 'SELECT REQUEST_ID, ''' || G_TXN_CREATE || ''', Transaction_Id, 1, ' || G_INTF_ORG_CODE || ', ';
640: l_dyn_sql_select := l_dyn_sql_select || 'DECODE(' || G_INTF_STRUCT_NAME || ',Bom_Globals.Retrieve_Message(''BOM'', ''BOM_PRIMARY''),NULL,' || G_INTF_STRUCT_NAME || '), ';

Line 684: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_INVENTORY_COMPS_INTERFACE ( REQUEST_ID, Transaction_Type, Transaction_Id, Process_Flag, ';

680: END IF;
681:
682: -- Start of process components for Delete
683: l_dyn_sql_insert := '';
684: l_dyn_sql_insert := l_dyn_sql_insert || 'INSERT INTO BOM_INVENTORY_COMPS_INTERFACE ( REQUEST_ID, Transaction_Type, Transaction_Id, Process_Flag, ';
685: l_dyn_sql_insert := l_dyn_sql_insert || 'ORGANIZATION_CODE, ALTERNATE_BOM_DESIGNATOR, COMPONENT_SEQUENCE_ID, ';
686: l_dyn_sql_insert := l_dyn_sql_insert || 'DELETE_GROUP_NAME, DG_DESCRIPTION, ';
687: l_dyn_sql_select := '';
688: l_dyn_sql_select := l_dyn_sql_select || 'SELECT REQUEST_ID, Transaction_Type, Transaction_Id, 1, ' || G_INTF_ORG_CODE || ', ';