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

Line 129: FROM MTL_SYSTEM_ITEMS_KFV mvl1

125: stmt_num := 3.1;
126: /* Update Assembly Item name */
127: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBMI
128: SET item_number = (SELECT concatenated_segments
129: FROM MTL_SYSTEM_ITEMS_KFV mvl1
130: WHERE mvl1.inventory_item_id = BBMI.assembly_item_id
131: and mvl1.organization_id = BBMI.organization_id)
132: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
133: AND upper(transaction_type) in (G_Create, G_Delete, G_Update,G_NoOp)

Line 142: FROM MTL_SYSTEM_ITEMS MKFV

138: ( (p_batch_id IS NULL) AND (BBMI.batch_id IS NULL) )
139: OR ( p_batch_id = BBMI.batch_id )
140: )
141: AND exists (SELECT 'x'
142: FROM MTL_SYSTEM_ITEMS MKFV
143: WHERE MKFV.inventory_item_id = BBMI.assembly_item_id
144: AND MKFV.organization_id = BBMI.organization_id);
145:
146: stmt_num := 4;

Line 151: FROM MTL_SYSTEM_ITEMS_KFV mvl1

147:
148: /* Update Assembly Item Id*/
149: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBMI
150: SET assembly_item_id = (SELECT inventory_item_id
151: FROM MTL_SYSTEM_ITEMS_KFV mvl1
152: WHERE mvl1.concatenated_segments = BBMI.item_number
153: AND mvl1.organization_id = BBMI.organization_id)
154: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
155: AND upper(transaction_type) in (G_Create, G_Delete, G_Update,G_NoOp)

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

248: /* Update Assembly Item name */
249:
250: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBMI
251: SET common_item_number = (SELECT concatenated_segments
252: FROM MTL_SYSTEM_ITEMS_KFV mvl1
253: WHERE mvl1.inventory_item_id = BBMI.common_assembly_item_id
254: AND mvl1.organization_id = BBMI.common_organization_id)
255: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
256: AND upper(transaction_type) in (G_Create, G_Delete, G_Update,G_NoOp)

Line 265: FROM MTL_SYSTEM_ITEMS mvl2

261: ( (p_batch_id IS NULL) AND (BBMI.batch_id IS NULL) )
262: OR ( p_batch_id = BBMI.batch_id )
263: )
264: AND exists (SELECT 'x'
265: FROM MTL_SYSTEM_ITEMS mvl2
266: WHERE mvl2.inventory_item_id = BBMI.common_assembly_item_id
267: AND mvl2.organization_id = BBMI.common_organization_id);
268:
269: /* Update the delete_group_name from bom_interface_delete_groups */

Line 321: FROM bom_bill_of_materials bom, mtl_system_items_vl mvll

317:
318: stmt_num := 9.7;
319: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBMI
320: SET bill_sequence_id = (SELECT bill_sequence_id
321: FROM bom_bill_of_materials bom, mtl_system_items_vl mvll
322: WHERE mvll.concatenated_segments = BBMI.item_number
323: AND mvll.organization_id = BBMI.organization_id
324: AND bom.assembly_item_id = mvll.inventory_item_id
325: AND bom.organization_id = mvll.organization_id

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

626: /* Update Assembly Item name */
627:
628: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
629: SET assembly_item_number = (SELECT concatenated_segments
630: FROM MTL_SYSTEM_ITEMS_KFV mvl1
631: WHERE mvl1.inventory_item_id = BICI.assembly_item_id
632: AND mvl1.organization_id = BICI.organization_id)
633: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
634: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 643: FROM mtl_system_items mvl12

639: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
640: OR ( p_batch_id = BICI.batch_id )
641: )
642: AND exists (SELECT 'x'
643: FROM mtl_system_items mvl12
644: WHERE mvl12.inventory_item_id = BICI.assembly_item_id
645: AND mvl12.organization_id = BICI.organization_id);
646:
647: stmt_num := 5.1;

Line 652: FROM MTL_SYSTEM_ITEMS_KFV mvl1

648: /* Update the Assembly Item Id */
649:
650: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
651: SET assembly_item_id = (SELECT inventory_item_id
652: FROM MTL_SYSTEM_ITEMS_KFV mvl1
653: WHERE mvl1.concatenated_segments = BICI.assembly_item_number
654: AND mvl1.organization_id = BICI.organization_id)
655: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
656: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 672: FROM MTL_SYSTEM_ITEMS_KFV mvl1

668: /* Update Component Item name */
669:
670: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
671: SET component_item_number = (SELECT CONCATENATED_SEGMENTS
672: FROM MTL_SYSTEM_ITEMS_KFV mvl1
673: WHERE mvl1.inventory_item_id = BICI.component_item_id
674: AND mvl1.organization_id = BICI.organization_id)
675: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
676: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 685: FROM mtl_system_items mvl12

681: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
682: OR ( p_batch_id = BICI.batch_id )
683: )
684: AND exists (SELECT 'x'
685: FROM mtl_system_items mvl12
686: WHERE mvl12.inventory_item_id = BICI.component_item_id
687: AND mvl12.organization_id = BICI.organization_id);
688:
689: stmt_num := 6.1;

Line 693: FROM mtl_system_items_kfv mvll

689: stmt_num := 6.1;
690: /* Update the component_item_id */
691: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
692: SET component_item_id = (SELECT inventory_item_id
693: FROM mtl_system_items_kfv mvll
694: WHERE mvll.concatenated_segments = BICI.component_item_number
695: AND mvll.organization_id = BICI.organization_id)
696: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
697: AND upper(transaction_type) in (G_Delete, G_Update)

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

1188: /* Update Assembly Item name */
1189:
1190: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1191: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1192: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1193: WHERE mvl1.inventory_item_id = BRDI.assembly_item_id
1194: and mvl1.organization_id = BRDI.organization_id)
1195: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1196: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1205: FROM mtl_system_items MKFV

1201: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
1202: OR ( p_batch_id = BRDI.batch_id )
1203: )
1204: AND exists (select 'x'
1205: FROM mtl_system_items MKFV
1206: WHERE MKFV.inventory_item_id = BRDI.assembly_item_id
1207: AND MKFV.organization_id = BRDI.organization_id );
1208:
1209:

Line 1215: FROM MTL_SYSTEM_ITEMS_KFV mvl1

1211: /* Update Component Item name */
1212:
1213: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1214: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1215: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1216: WHERE mvl1.inventory_item_id = BRDI.component_item_id
1217: AND mvl1.organization_id = BRDI.organization_id)
1218: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1219: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1228: FROM mtl_system_items MKFV

1224: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
1225: OR ( p_batch_id = BRDI.batch_id )
1226: )
1227: AND exists (SELECT 'x'
1228: FROM mtl_system_items MKFV
1229: WHERE MKFV.inventory_item_id = BRDI.component_item_id
1230: AND MKFV.organization_id = BRDI.organization_id);
1231:
1232:

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

1458: /* Update Assembly Item name */
1459:
1460: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1461: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1462: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1463: WHERE mvl1.inventory_item_id = BSCI.assembly_item_id
1464: AND mvl1.organization_id = BSCI.organization_id)
1465: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1466: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1475: FROM mtl_system_items MKFV

1471: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
1472: OR ( p_batch_id = BSCI.batch_id )
1473: )
1474: AND exists (SELECT 'x'
1475: FROM mtl_system_items MKFV
1476: WHERE MKFV.inventory_item_id = BSCI.assembly_item_id
1477: AND MKFV.organization_id = BSCI.organization_id);
1478:
1479:

Line 1485: FROM MTL_SYSTEM_ITEMS_KFV mvl1

1481: /* Update Component Item name */
1482:
1483: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1484: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1485: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1486: WHERE mvl1.inventory_item_id = BSCI.component_item_id
1487: AND mvl1.organization_id = BSCI.organization_id)
1488: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1489: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1498: FROM mtl_system_items MKFV

1494: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
1495: OR ( p_batch_id = BSCI.batch_id )
1496: )
1497: AND exists (SELECT 'x'
1498: FROM mtl_system_items MKFV
1499: WHERE MKFV.inventory_item_id = BSCI.component_item_id
1500: AND MKFV.organization_id = BSCI.organization_id);
1501:
1502:

Line 1508: FROM MTL_SYSTEM_ITEMS_KFV mvl1

1504: /* Update Substitute Component name if Id is given */
1505:
1506: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1507: SET SUBSTITUTE_COMP_NUMBER = (SELECT CONCATENATED_SEGMENTS
1508: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1509: WHERE mvl1.inventory_item_id = BSCI.SUBSTITUTE_COMPONENT_ID
1510: and mvl1.organization_id = BSCI.organization_id)
1511: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1512: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1521: FROM mtl_system_items MKFV

1517: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
1518: OR ( p_batch_id = BSCI.batch_id )
1519: )
1520: AND exists (SELECT 'x'
1521: FROM mtl_system_items MKFV
1522: WHERE MKFV.inventory_item_id = BSCI.substitute_component_id
1523: AND MKFV.organization_id = BSCI.organization_id);
1524:
1525:

Line 1532: FROM MTL_SYSTEM_ITEMS_KFV mvl1

1528: /* Update new Substitute Component name if Id is given */
1529:
1530: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1531: SET NEW_SUB_COMP_NUMBER = (SELECT CONCATENATED_SEGMENTS
1532: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1533: WHERE mvl1.inventory_item_id = BSCI.NEW_SUB_COMP_ID
1534: and mvl1.organization_id = BSCI.organization_id)
1535: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1536: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1545: FROM mtl_system_items MKFV

1541: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
1542: OR ( p_batch_id = BSCI.batch_id )
1543: )
1544: AND exists (SELECT 'x'
1545: FROM mtl_system_items MKFV
1546: WHERE MKFV.inventory_item_id = BSCI.new_sub_comp_id
1547: AND MKFV.organization_id = BSCI.organization_id);
1548:
1549: stmt_num := 9;

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

1775: /* Update Assembly Item name */
1776:
1777: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1778: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1779: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1780: WHERE mvl1.inventory_item_id = BCOI.assembly_item_id
1781: and mvl1.organization_id = BCOI.organization_id)
1782: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1783: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1792: FROM mtl_system_items MKFV

1788: ( (p_batch_id IS NULL) AND (BCOI.batch_id IS NULL) )
1789: OR ( p_batch_id = BCOI.batch_id )
1790: )
1791: AND exists (SELECT 'x'
1792: FROM mtl_system_items MKFV
1793: WHERE MKFV.inventory_item_id = BCOI.assembly_item_id
1794: AND MKFV.organization_id = BCOI.organization_id);
1795:
1796:

Line 1802: FROM MTL_SYSTEM_ITEMS_KFV mvl1

1798: /* Update Component Item name */
1799:
1800: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1801: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1802: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1803: WHERE mvl1.inventory_item_id = BCOI.component_item_id
1804: and mvl1.organization_id = BCOI.organization_id)
1805: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1806: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1815: FROM mtl_system_items MKFV

1811: ( (p_batch_id IS NULL) AND (BCOI.batch_id IS NULL) )
1812: OR ( p_batch_id = BCOI.batch_id )
1813: )
1814: AND exists (SELECT 'x'
1815: FROM mtl_system_items MKFV
1816: WHERE MKFV.inventory_item_id = BCOI.component_item_id
1817: AND MKFV.organization_id = BCOI.organization_id);
1818:
1819:

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

1981: /* Update Assembly Item name */
1982:
1983: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
1984: SET item_number = (SELECT concatenated_segments
1985: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1986: WHERE mvl1.inventory_item_id = MIRI.inventory_item_id
1987: and mvl1.organization_id = MIRI.organization_id)
1988: WHERE process_flag = 1
1989: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1994: FROM mtl_system_items mvl2

1990: AND inventory_item_id is not null
1991: AND organization_id is not null
1992: AND MIRI.set_process_id = l_set_process_id
1993: AND exists (SELECT 'x'
1994: FROM mtl_system_items mvl2
1995: WHERE mvl2.inventory_item_id = MIRI.inventory_item_id
1996: and mvl2.organization_id = MIRI.organization_id);
1997:
1998:

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 2243: FROM mtl_system_items_kfv MKFV

2239:
2240: /* Update the Assembly_item_number */
2241: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2242: SET assembly_item_number = (SELECT concatenated_segments
2243: FROM mtl_system_items_kfv MKFV
2244: WHERE MKFV.inventory_item_id = BICI.Assembly_item_id
2245: AND MKFV.organization_id = BICI.organization_id)
2246: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2247: AND upper(transaction_type) in (G_Delete, G_Update, G_Create,G_NoOp)

Line 2256: FROM mtl_system_items MKFV2

2252: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2253: OR ( p_batch_id = BICI.batch_id )
2254: )
2255: AND exists (SELECT 'x'
2256: FROM mtl_system_items MKFV2
2257: WHERE MKFV2.inventory_item_id = BICI.Assembly_item_id
2258: AND MKFV2.organization_id = BICI.organization_id);
2259:
2260:

Line 2265: FROM mtl_system_items_kfv mvll

2261:
2262: /* Update the Assembly_item_id */
2263: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2264: SET Assembly_item_id = (SELECT inventory_item_id
2265: FROM mtl_system_items_kfv mvll
2266: WHERE mvll.concatenated_segments = BICI.Assembly_item_number
2267: AND mvll.organization_id = BICI.organization_id)
2268: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2269: AND upper(transaction_type) in (G_Delete, G_Update, G_Create,G_NoOp)

Line 2282: FROM mtl_system_items_kfv mvll

2278:
2279: /* Update component_item_number */
2280: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2281: SET component_item_number = (SELECT concatenated_segments
2282: FROM mtl_system_items_kfv mvll
2283: WHERE mvll.inventory_item_id = BICI.Component_item_id
2284: AND mvll.organization_id = BICI.organization_id)
2285: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2286: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)

Line 2295: FROM mtl_system_items MKFV

2291: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2292: OR ( p_batch_id = BICI.batch_id )
2293: )
2294: AND exists (SELECT 'x'
2295: FROM mtl_system_items MKFV
2296: WHERE MKFV.inventory_item_id = BICI.Component_item_id
2297: AND MKFV.organization_id = BICI.organization_id);
2298:
2299: /* Update the component_item_id */

Line 2302: FROM mtl_system_items_kfv mvll

2298:
2299: /* Update the component_item_id */
2300: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2301: SET component_item_id = (SELECT inventory_item_id
2302: FROM mtl_system_items_kfv mvll
2303: WHERE mvll.concatenated_segments = BICI.Component_item_number
2304: AND mvll.organization_id = BICI.organization_id)
2305: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2306: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)

Line 2407: FROM mtl_system_items_kfv mvll

2403:
2404: /* Update the From_end_item_id */
2405: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2406: SET From_End_Item_id = (SELECT inventory_item_id
2407: FROM mtl_system_items_kfv mvll
2408: WHERE mvll.concatenated_segments = BICI.From_End_Item
2409: AND mvll.organization_id = BICI.organization_id)
2410: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2411: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)

Line 2420: FROM mtl_system_items_kfv mvll2

2416: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2417: OR ( p_batch_id = BICI.batch_id )
2418: )
2419: AND exists (SELECT 'x'
2420: FROM mtl_system_items_kfv mvll2
2421: WHERE mvll2.concatenated_segments = BICI.From_End_Item
2422: AND mvll2.organization_id = BICI.organization_id);
2423:
2424: /* Update the From_end_item_rev_id */

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

2640: /* Update Assembly Item name */
2641:
2642: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2643: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
2644: FROM MTL_SYSTEM_ITEMS_KFV mvl1
2645: WHERE mvl1.inventory_item_id = BRDI.assembly_item_id
2646: AND mvl1.organization_id = BRDI.organization_id)
2647: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2648: AND assembly_item_id is not null

Line 2656: FROM mtl_system_items mvl12

2652: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
2653: OR ( p_batch_id = BRDI.batch_id )
2654: )
2655: AND exists (SELECT 'x'
2656: FROM mtl_system_items mvl12
2657: WHERE mvl12.inventory_item_id = BRDI.assembly_item_id
2658: AND mvl12.organization_id = BRDI.organization_id);
2659:
2660: /* Update the Assembly_item_id */

Line 2663: FROM mtl_system_items_kfv mvll

2659:
2660: /* Update the Assembly_item_id */
2661: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2662: SET Assembly_item_id = (SELECT inventory_item_id
2663: FROM mtl_system_items_kfv mvll
2664: WHERE mvll.concatenated_segments = BRDI.Assembly_item_number
2665: AND mvll.organization_id = BRDI.organization_id)
2666: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2667: AND Assembly_item_number is not null

Line 2679: FROM MTL_SYSTEM_ITEMS_KFV mvl1

2675:
2676: /* Update Component Item name */
2677: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2678: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
2679: FROM MTL_SYSTEM_ITEMS_KFV mvl1
2680: WHERE mvl1.inventory_item_id = BRDI.component_item_id
2681: AND mvl1.organization_id = BRDI.organization_id)
2682: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2683: AND COMPONENT_ITEM_ID is not null

Line 2691: FROM mtl_system_items mvl12

2687: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
2688: OR ( p_batch_id = BRDI.batch_id )
2689: )
2690: AND exists (SELECT 'x'
2691: FROM mtl_system_items mvl12
2692: WHERE mvl12.inventory_item_id = BRDI.component_item_id
2693: AND mvl12.organization_id = BRDI.organization_id);
2694:
2695:

Line 2699: FROM mtl_system_items_kfv mvll

2695:
2696: /* Update the Component_item_id */
2697: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2698: SET Component_item_id = (SELECT inventory_item_id
2699: FROM mtl_system_items_kfv mvll
2700: WHERE mvll.concatenated_segments = BRDI.Component_item_number
2701: AND mvll.organization_id = BRDI.organization_id)
2702: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2703: AND Component_item_number is not null

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

2906: /* Update Assembly Item name */
2907:
2908: UPDATE bom_sub_comps_interface BSCI
2909: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
2910: FROM MTL_SYSTEM_ITEMS_KFV mvl1
2911: WHERE mvl1.inventory_item_id = BSCI.assembly_item_id
2912: AND mvl1.organization_id = BSCI.organization_id)
2913: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2914: AND assembly_item_id is not null

Line 2922: FROM mtl_system_items mvl12

2918: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
2919: OR ( p_batch_id = BSCI.batch_id )
2920: )
2921: AND exists (SELECT 'x'
2922: FROM mtl_system_items mvl12
2923: WHERE mvl12.inventory_item_id = BSCI.assembly_item_id
2924: AND mvl12.organization_id = BSCI.organization_id);
2925:
2926: /* Update the Assembly_item_id */

Line 2929: FROM mtl_system_items_kfv mvll

2925:
2926: /* Update the Assembly_item_id */
2927: UPDATE bom_sub_comps_interface BSCI
2928: SET Assembly_item_id = (SELECT inventory_item_id
2929: FROM mtl_system_items_kfv mvll
2930: WHERE mvll.concatenated_segments = BSCI.Assembly_item_number
2931: AND mvll.organization_id = BSCI.organization_id)
2932: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2933: AND Assembly_item_number is not null

Line 2945: FROM MTL_SYSTEM_ITEMS_KFV mvl1

2941:
2942: /* Update Component Item name */
2943: UPDATE bom_sub_comps_interface BSCI
2944: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
2945: FROM MTL_SYSTEM_ITEMS_KFV mvl1
2946: WHERE mvl1.inventory_item_id = BSCI.component_item_id
2947: AND mvl1.organization_id = BSCI.organization_id)
2948: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2949: AND COMPONENT_ITEM_ID is not null

Line 2957: FROM mtl_system_items mvl12

2953: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
2954: OR ( p_batch_id = BSCI.batch_id )
2955: )
2956: AND exists (SELECT 'x'
2957: FROM mtl_system_items mvl12
2958: WHERE mvl12.inventory_item_id = BSCI.component_item_id
2959: AND mvl12.organization_id = BSCI.organization_id);
2960:
2961:

Line 2965: FROM mtl_system_items_kfv mvll

2961:
2962: /* Update the Component_item_id */
2963: UPDATE bom_sub_comps_interface BSCI
2964: SET Component_item_id = (SELECT inventory_item_id
2965: FROM mtl_system_items_kfv mvll
2966: WHERE mvll.concatenated_segments = BSCI.Component_item_number
2967: AND mvll.organization_id = BSCI.organization_id)
2968: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2969: AND Component_item_number is not null

Line 3019: FROM MTL_SYSTEM_ITEMS_KFV mvl1

3015:
3016:
3017: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
3018: SET SUBSTITUTE_COMP_NUMBER = (SELECT concatenated_segments
3019: FROM MTL_SYSTEM_ITEMS_KFV mvl1
3020: WHERE mvl1.inventory_item_id = BSCI.SUBSTITUTE_COMPONENT_ID
3021: and mvl1.organization_id = BSCI.organization_id)
3022: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
3023: AND upper(transaction_type) in (G_Create, G_Delete, G_Update,'SYNC')

Line 3032: FROM mtl_system_items mvl12

3028: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
3029: OR ( p_batch_id = BSCI.batch_id )
3030: )
3031: AND exists (SELECT 'x'
3032: FROM mtl_system_items mvl12
3033: WHERE mvl12.inventory_item_id = BSCI.SUBSTITUTE_COMPONENT_ID
3034: AND mvl12.organization_id = BSCI.organization_id);
3035:
3036: --Update Sub Comp Number If id is given

Line 3040: FROM MTL_SYSTEM_ITEMS_KFV mvl1

3036: --Update Sub Comp Number If id is given
3037:
3038: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
3039: SET SUBSTITUTE_COMPONENT_ID = (SELECT inventory_item_id
3040: FROM MTL_SYSTEM_ITEMS_KFV mvl1
3041: WHERE mvl1.concatenated_segments = BSCI.SUBSTITUTE_COMP_NUMBER
3042: and mvl1.organization_id = BSCI.organization_id)
3043: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
3044: AND upper(transaction_type) in (G_Create, G_Delete, G_Update,'SYNC')

Line 3058: FROM MTL_SYSTEM_ITEMS_KFV mvl1

3054: --Update New Sub Comp Number
3055:
3056: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
3057: SET NEW_SUB_COMP_NUMBER = (SELECT CONCATENATED_SEGMENTS
3058: FROM MTL_SYSTEM_ITEMS_KFV mvl1
3059: WHERE mvl1.inventory_item_id = BSCI.NEW_SUB_COMP_ID
3060: and mvl1.organization_id = BSCI.organization_id)
3061: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
3062: AND upper(transaction_type) in (G_Create, G_Delete, G_Update,'SYNC')

Line 3071: FROM mtl_system_items mvl12

3067: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
3068: OR ( p_batch_id = BSCI.batch_id )
3069: )
3070: AND exists (SELECT 'x'
3071: FROM mtl_system_items mvl12
3072: WHERE mvl12.inventory_item_id = BSCI.NEW_SUB_COMP_ID
3073: and mvl12.organization_id = BSCI.organization_id);
3074:
3075:

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