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_OPEN_INTERFACE_UTL dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 169: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

165: stmt_num := 5;
166: /* Assign transaction ids */
167:
168: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBMI
169: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
170: transaction_type = upper(transaction_type)
171: WHERE transaction_id is null
172: AND upper(transaction_type) in (G_Create, G_Update, G_Delete,'NO_OP')
173: AND (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 447: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

443: PROGRAM_UPDATE_DATE
444: )
445: Select
446: BBMI.transaction_id,
447: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
448: Null,
449: null,
450: 'BOM_BILL_OF_MTLS_INTERFACE',
451: decode ( BBMI.Organization_code, null, msg_name1,msg_name2),

Line 720: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

716: stmt_num := 7;
717: /* Assign transaction ids */
718:
719: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
720: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
721: transaction_type = upper(transaction_type)
722: WHERE transaction_id is null
723: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
724: AND (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1026: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1022: PROGRAM_UPDATE_DATE
1023: )
1024: Select
1025: BICI.transaction_id,
1026: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1027: Null,
1028: null,
1029: 'BOM_INVENTORY_COMPS_INTERFACE',
1030: decode ( BICI.Organization_code, null, msg_name1,msg_name2),

Line 1261: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1257: stmt_num := 7;
1258: /* Assign transaction ids */
1259:
1260: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1261: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1262: transaction_type = upper(transaction_type)
1263: WHERE transaction_id is null
1264: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
1265: AND (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1310: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1306: PROGRAM_UPDATE_DATE
1307: )
1308: Select
1309: BRDI.transaction_id,
1310: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1311: Null,
1312: null,
1313: 'BOM_REF_DESGS_INTERFACE',
1314: decode ( BRDI.Organization_code, null, msg_name1,msg_name2),

Line 1588: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1584: stmt_num := 9;
1585: /* Assign transaction ids */
1586:
1587: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1588: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1589: transaction_type = upper(transaction_type)
1590: WHERE transaction_id is null
1591: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
1592: AND (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1636: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1632: PROGRAM_UPDATE_DATE
1633: )
1634: Select
1635: BSCI.transaction_id,
1636: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1637: Null,
1638: null,
1639: 'BOM_INVENTORY_COMPS_INTERFACE',
1640: decode ( BSCI.Organization_code, null, msg_name1,msg_name2),

Line 1862: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1858: stmt_num := 8;
1859: /* Assign transaction ids */
1860:
1861: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1862: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1863: transaction_type = upper(transaction_type)
1864: WHERE transaction_id is null
1865: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
1866: AND (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1910: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1906: PROGRAM_UPDATE_DATE
1907: )
1908: Select
1909: BCOI.transaction_id,
1910: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1911: Null,
1912: null,
1913: 'BOM_COMPONENT_OPS_INTERFACE',
1914: decode ( BCOI.Organization_code, null, msg_name1,msg_name2),

Line 2045: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

2041: stmt_num := 5;
2042: /* Assign transaction ids */
2043:
2044: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
2045: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
2046: transaction_type = upper(transaction_type)
2047: WHERE transaction_id is null
2048: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
2049: AND process_flag = 1

Line 2091: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

2087: PROGRAM_UPDATE_DATE
2088: )
2089: Select
2090: MIRI.transaction_id,
2091: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
2092: Null,
2093: null,
2094: 'MTL_ITEM_REVISIONS_INTERFACE',
2095: decode ( MIRI.Organization_code, null, msg_name1,msg_name2),

Line 2578: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

2574: WHERE mil2.concatenated_segments = BICI.location_name
2575: AND mil2.organization_id = BICI.organization_id);
2576:
2577: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2578: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
2579: transaction_type = upper(transaction_type)
2580: WHERE transaction_id is null
2581: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
2582: AND (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 2843: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

2839:
2840: /* Assign transaction ids */
2841:
2842: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2843: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
2844: transaction_type = upper(transaction_type)
2845: WHERE transaction_id is null
2846: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
2847: AND (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 3152: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

3148:
3149: /* Assign transaction ids */
3150:
3151: UPDATE bom_sub_comps_interface BSCI
3152: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
3153: transaction_type = upper(transaction_type)
3154: WHERE transaction_id is null
3155: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
3156: AND (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import