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_RTG_OI_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 133: FROM MTL_SYSTEM_ITEMS_KFV mvl1

129: /* Update Assembly Item name */
130:
131: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
132: SET assembly_item_number = (SELECT concatenated_segments
133: FROM MTL_SYSTEM_ITEMS_KFV mvl1
134: WHERE mvl1.inventory_item_id = BORI.assembly_item_id
135: and mvl1.organization_id = BORI.organization_id)
136: WHERE process_flag = 1
137: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 146: FROM MTL_SYSTEM_ITEMS mvl2

142: ( (p_batch_id IS NULL) AND (BORI.batch_id IS NULL) )
143: OR ( p_batch_id = BORI.batch_id )
144: )
145: AND exists (SELECT 'x'
146: FROM MTL_SYSTEM_ITEMS mvl2
147: WHERE mvl2.inventory_item_id = BORI.assembly_item_id
148: and mvl2.organization_id = BORI.organization_id);
149:
150:

Line 156: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

152: stmt_num := 5;
153: /* Assign transaction ids */
154:
155: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
156: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
157: WHERE transaction_id is null
158: --Bug 3411601 AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
159: AND upper(transaction_type) in (G_Create, G_Update, G_Delete, 'NO_OP')
160: AND process_flag = 1

Line 211: FROM MTL_SYSTEM_ITEMS_KFV mvl1

207: /* Update Assembly Item name */
208:
209: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
210: SET common_item_number = (SELECT concatenated_segments
211: FROM MTL_SYSTEM_ITEMS_KFV mvl1
212: WHERE mvl1.inventory_item_id = BORI.common_assembly_item_id
213: and mvl1.organization_id = BORI.organization_id)
214: WHERE process_flag = 1
215: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 224: FROM MTL_SYSTEM_ITEMS mvl2

220: ( (p_batch_id IS NULL) AND (BORI.batch_id IS NULL) )
221: OR ( p_batch_id = BORI.batch_id )
222: )
223: AND exists (SELECT 'x'
224: FROM MTL_SYSTEM_ITEMS mvl2
225: WHERE mvl2.inventory_item_id = BORI.common_assembly_item_id
226: and mvl2.organization_id = BORI.organization_id);
227:
228:

Line 383: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

379: PROGRAM_UPDATE_DATE
380: )
381: Select
382: BORI.transaction_id,
383: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
384: Null,
385: null,
386: 'BOM_OP_ROUTINGS_INTERFACE',
387: decode ( BORI.Organization_code, null, msg_name1,msg_name2),

Line 561: FROM MTL_SYSTEM_ITEMS_KFV mvl1

557: /* Update Assembly Item name */
558:
559: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
560: SET assembly_item_number = (SELECT concatenated_segments
561: FROM MTL_SYSTEM_ITEMS_KFV mvl1
562: WHERE mvl1.inventory_item_id = BOSI.assembly_item_id
563: and mvl1.organization_id = BOSI.organization_id)
564: WHERE process_flag = 1
565: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 574: FROM MTL_SYSTEM_ITEMS mvl2

570: ( (p_batch_id IS NULL) AND (BOSI.batch_id IS NULL) )
571: OR ( p_batch_id = BOSI.batch_id )
572: )
573: AND exists (SELECT 'x'
574: FROM MTL_SYSTEM_ITEMS mvl2
575: WHERE mvl2.inventory_item_id = BOSI.assembly_item_id
576: and mvl2.organization_id = BOSI.organization_id);
577:
578:

Line 583: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

579: stmt_num := 6;
580: /* Assign transaction ids */
581:
582: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
583: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
584: WHERE transaction_id is null
585: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
586: AND process_flag = 1
587: AND

Line 947: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

943: PROGRAM_UPDATE_DATE
944: )
945: Select
946: BOSI.transaction_id,
947: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
948: Null,
949: null,
950: 'BOM_OP_SEQUENCES_INTERFACE',
951: decode ( BOSI.Organization_code, null, msg_name1,msg_name2),

Line 1122: FROM MTL_SYSTEM_ITEMS_KFV mvl1

1118: /* Update Assembly Item name */
1119:
1120: UPDATE BOM_OP_RESOURCES_INTERFACE BORI
1121: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1122: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1123: WHERE mvl1.inventory_item_id = BORI.assembly_item_id
1124: and mvl1.organization_id = BORI.organization_id)
1125: WHERE process_flag = 1
1126: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1135: FROM MTL_SYSTEM_ITEMS mvl2

1131: ( (p_batch_id IS NULL) AND (BORI.batch_id IS NULL) )
1132: OR ( p_batch_id = BORI.batch_id )
1133: )
1134: AND exists (SELECT 'x'
1135: FROM MTL_SYSTEM_ITEMS mvl2
1136: WHERE mvl2.inventory_item_id = BORI.assembly_item_id
1137: and mvl2.organization_id = BORI.organization_id);
1138:
1139:

Line 1167: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1163: stmt_num := 7;
1164: /* Assign transaction ids */
1165:
1166: UPDATE BOM_OP_RESOURCES_INTERFACE BORI
1167: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1168: WHERE transaction_id is null
1169: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
1170: AND process_flag = 1
1171: AND

Line 1226: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1222: PROGRAM_UPDATE_DATE
1223: )
1224: Select
1225: BORI.transaction_id,
1226: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1227: Null,
1228: null,
1229: 'BOM_OP_RESOURCES_INTERFACE',
1230: decode ( BORI.Organization_code, null, msg_name1,msg_name2),

Line 1399: FROM MTL_SYSTEM_ITEMS_KFV mvl1

1395: /* Update Assembly Item name */
1396:
1397: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI
1398: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1399: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1400: WHERE mvl1.inventory_item_id = BSORI.assembly_item_id
1401: and mvl1.organization_id = BSORI.organization_id)
1402: WHERE process_flag = 1
1403: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1412: FROM MTL_SYSTEM_ITEMS mvl2

1408: ( (p_batch_id IS NULL) AND (BSORI.batch_id IS NULL) )
1409: OR ( p_batch_id = BSORI.batch_id )
1410: )
1411: AND exists (SELECT 'x'
1412: FROM MTL_SYSTEM_ITEMS mvl2
1413: WHERE mvl2.inventory_item_id = BSORI.assembly_item_id
1414: and mvl2.organization_id = BSORI.organization_id);
1415:
1416:

Line 1444: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1440: stmt_num := 7;
1441: /* Assign transaction ids */
1442:
1443: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI
1444: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1445: WHERE transaction_id is null
1446: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
1447: AND process_flag = 1
1448: AND

Line 1502: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1498: PROGRAM_UPDATE_DATE
1499: )
1500: Select
1501: BSORI.transaction_id,
1502: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1503: Null,
1504: null,
1505: 'BOM_SUB_OP_RESOURCES_INTERFACE',
1506: decode ( BSORI.Organization_code, null, msg_name1,msg_name2),

Line 1693: FROM MTL_SYSTEM_ITEMS_KFV mvl1

1689: /* Update Assembly Item name */
1690:
1691: UPDATE BOM_OP_NETWORKS_INTERFACE BONI
1692: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1693: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1694: WHERE mvl1.inventory_item_id = BONI.assembly_item_id
1695: and mvl1.organization_id = BONI.organization_id)
1696: WHERE process_flag = 1
1697: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1706: FROM MTL_SYSTEM_ITEMS mvl2

1702: ( (p_batch_id IS NULL) AND (BONI.batch_id IS NULL) )
1703: OR ( p_batch_id = BONI.batch_id )
1704: )
1705: AND exists (SELECT 'x'
1706: FROM MTL_SYSTEM_ITEMS mvl2
1707: WHERE mvl2.inventory_item_id = BONI.assembly_item_id
1708: and mvl2.organization_id = BONI.organization_id);
1709:
1710:

Line 1714: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1710:
1711: stmt_num := 6;
1712: /* Assign transaction ids */
1713: UPDATE BOM_OP_NETWORKS_INTERFACE BONI
1714: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1715: WHERE transaction_id is null
1716: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
1717: AND process_flag = 1
1718: AND

Line 1773: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1769: PROGRAM_UPDATE_DATE
1770: )
1771: Select
1772: BONI.transaction_id,
1773: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1774: Null,
1775: null,
1776: 'BOM_OP_NETWORKS_INTERFACE',
1777: decode ( BONI.Organization_code, null, msg_name1,msg_name2),

Line 1903: FROM MTL_SYSTEM_ITEMS_KFV mvl1

1899: /* Update Assembly Item name */
1900:
1901: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI
1902: SET inventory_item_number = (SELECT concatenated_segments
1903: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1904: WHERE mvl1.inventory_item_id = MRIRI.inventory_item_id
1905: and mvl1.organization_id = MRIRI.organization_id)
1906: WHERE process_flag = 1
1907: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1916: FROM MTL_SYSTEM_ITEMS mvl2

1912: ( (p_batch_id IS NULL) AND (MRIRI.batch_id IS NULL) )
1913: OR ( p_batch_id = MRIRI.batch_id )
1914: )
1915: AND exists (SELECT 'x'
1916: FROM MTL_SYSTEM_ITEMS mvl2
1917: WHERE mvl2.inventory_item_id = MRIRI.inventory_item_id
1918: and mvl2.organization_id = MRIRI.organization_id);
1919:
1920:

Line 1926: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1922: stmt_num := 4;
1923: /* Assign transaction ids */
1924:
1925: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI
1926: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1927: WHERE transaction_id is null
1928: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
1929: AND process_flag = 1
1930: AND

Line 1987: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1983: PROGRAM_UPDATE_DATE
1984: )
1985: Select
1986: MRIRI.transaction_id,
1987: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1988: Null,
1989: null,
1990: 'MTL_RTG_ITEM_REVS_INTERFACE',
1991: decode ( MRIRI.Organization_code, null, msg_name1,msg_name2),