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 712: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

708: stmt_num := 7;
709: /* Assign transaction ids */
710:
711: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
712: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
713: transaction_type = upper(transaction_type)
714: WHERE transaction_id is null
715: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
716: AND (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1010: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1006: PROGRAM_UPDATE_DATE
1007: )
1008: Select
1009: BICI.transaction_id,
1010: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1011: Null,
1012: null,
1013: 'BOM_INVENTORY_COMPS_INTERFACE',
1014: decode ( BICI.Organization_code, null, msg_name1,msg_name2),

Line 1237: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1233: stmt_num := 7;
1234: /* Assign transaction ids */
1235:
1236: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1237: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1238: transaction_type = upper(transaction_type)
1239: WHERE transaction_id is null
1240: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
1241: AND (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1285: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1281: PROGRAM_UPDATE_DATE
1282: )
1283: Select
1284: BRDI.transaction_id,
1285: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1286: Null,
1287: null,
1288: 'BOM_REF_DESGS_INTERFACE',
1289: decode ( BRDI.Organization_code, null, msg_name1,msg_name2),

Line 1553: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1549: stmt_num := 9;
1550: /* Assign transaction ids */
1551:
1552: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1553: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1554: transaction_type = upper(transaction_type)
1555: WHERE transaction_id is null
1556: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
1557: AND (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1600: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1596: PROGRAM_UPDATE_DATE
1597: )
1598: Select
1599: BSCI.transaction_id,
1600: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1601: Null,
1602: null,
1603: 'BOM_INVENTORY_COMPS_INTERFACE',
1604: decode ( BSCI.Organization_code, null, msg_name1,msg_name2),

Line 1824: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1820: stmt_num := 8;
1821: /* Assign transaction ids */
1822:
1823: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1824: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1825: transaction_type = upper(transaction_type)
1826: WHERE transaction_id is null
1827: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
1828: AND (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1872: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1868: PROGRAM_UPDATE_DATE
1869: )
1870: Select
1871: BCOI.transaction_id,
1872: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1873: Null,
1874: null,
1875: 'BOM_COMPONENT_OPS_INTERFACE',
1876: decode ( BCOI.Organization_code, null, msg_name1,msg_name2),

Line 2004: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

2000: stmt_num := 5;
2001: /* Assign transaction ids */
2002:
2003: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
2004: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
2005: transaction_type = upper(transaction_type)
2006: WHERE transaction_id is null
2007: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
2008: AND process_flag = 1

Line 2049: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

2045: PROGRAM_UPDATE_DATE
2046: )
2047: Select
2048: MIRI.transaction_id,
2049: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
2050: Null,
2051: null,
2052: 'MTL_ITEM_REVISIONS_INTERFACE',
2053: decode ( MIRI.Organization_code, null, msg_name1,msg_name2),

Line 2534: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

2530: WHERE mil2.concatenated_segments = BICI.location_name
2531: AND mil2.organization_id = BICI.organization_id);
2532:
2533: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2534: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
2535: transaction_type = upper(transaction_type)
2536: WHERE transaction_id is null
2537: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
2538: AND (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 2799: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

2795:
2796: /* Assign transaction ids */
2797:
2798: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2799: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
2800: transaction_type = upper(transaction_type)
2801: WHERE transaction_id is null
2802: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
2803: AND (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 3108: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

3104:
3105: /* Assign transaction ids */
3106:
3107: UPDATE bom_sub_comps_interface BSCI
3108: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
3109: transaction_type = upper(transaction_type)
3110: WHERE transaction_id is null
3111: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
3112: AND (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import