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 563: FROM MTL_SYSTEM_ITEMS_KFV mvl1

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

Line 576: FROM MTL_SYSTEM_ITEMS mvl2

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

Line 585: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

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

Line 949: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

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

Line 1124: FROM MTL_SYSTEM_ITEMS_KFV mvl1

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

Line 1137: FROM MTL_SYSTEM_ITEMS mvl2

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

Line 1169: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

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

Line 1228: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

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

Line 1401: FROM MTL_SYSTEM_ITEMS_KFV mvl1

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

Line 1414: FROM MTL_SYSTEM_ITEMS mvl2

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

Line 1446: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

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

Line 1504: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

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

Line 1695: FROM MTL_SYSTEM_ITEMS_KFV mvl1

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

Line 1708: FROM MTL_SYSTEM_ITEMS mvl2

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

Line 1716: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

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

Line 1775: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

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

Line 1905: FROM MTL_SYSTEM_ITEMS_KFV mvl1

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

Line 1918: FROM MTL_SYSTEM_ITEMS mvl2

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

Line 1928: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

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

Line 1989: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

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