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

630: /* Update Assembly Item name */
631:
632: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
633: SET assembly_item_number = (SELECT concatenated_segments
634: FROM MTL_SYSTEM_ITEMS_KFV mvl1
635: WHERE mvl1.inventory_item_id = BICI.assembly_item_id
636: AND mvl1.organization_id = BICI.organization_id)
637: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
638: AND change_notice is null --added for bug 9673701

Line 648: FROM mtl_system_items mvl12

644: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
645: OR ( p_batch_id = BICI.batch_id )
646: )
647: AND exists (SELECT 'x'
648: FROM mtl_system_items mvl12
649: WHERE mvl12.inventory_item_id = BICI.assembly_item_id
650: AND mvl12.organization_id = BICI.organization_id);
651:
652: stmt_num := 5.1;

Line 657: FROM MTL_SYSTEM_ITEMS_KFV mvl1

653: /* Update the Assembly Item Id */
654:
655: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
656: SET assembly_item_id = (SELECT inventory_item_id
657: FROM MTL_SYSTEM_ITEMS_KFV mvl1
658: WHERE mvl1.concatenated_segments = BICI.assembly_item_number
659: AND mvl1.organization_id = BICI.organization_id)
660: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
661: AND change_notice is null --added for bug 9673701

Line 678: FROM MTL_SYSTEM_ITEMS_KFV mvl1

674: /* Update Component Item name */
675:
676: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
677: SET component_item_number = (SELECT CONCATENATED_SEGMENTS
678: FROM MTL_SYSTEM_ITEMS_KFV mvl1
679: WHERE mvl1.inventory_item_id = BICI.component_item_id
680: AND mvl1.organization_id = BICI.organization_id)
681: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
682: AND change_notice is null --added for bug 9673701

Line 692: FROM mtl_system_items mvl12

688: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
689: OR ( p_batch_id = BICI.batch_id )
690: )
691: AND exists (SELECT 'x'
692: FROM mtl_system_items mvl12
693: WHERE mvl12.inventory_item_id = BICI.component_item_id
694: AND mvl12.organization_id = BICI.organization_id);
695:
696: stmt_num := 6.1;

Line 700: FROM mtl_system_items_kfv mvll

696: stmt_num := 6.1;
697: /* Update the component_item_id */
698: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
699: SET component_item_id = (SELECT inventory_item_id
700: FROM mtl_system_items_kfv mvll
701: WHERE mvll.concatenated_segments = BICI.component_item_number
702: AND mvll.organization_id = BICI.organization_id)
703: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
704: AND change_notice is null --added for bug 9673701

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

1210: /* Update Assembly Item name */
1211:
1212: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1213: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1214: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1215: WHERE mvl1.inventory_item_id = BRDI.assembly_item_id
1216: and mvl1.organization_id = BRDI.organization_id)
1217: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1218: AND change_notice is null --added for bug 9673701

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.assembly_item_id
1230: AND MKFV.organization_id = BRDI.organization_id );
1231:
1232:

Line 1238: FROM MTL_SYSTEM_ITEMS_KFV mvl1

1234: /* Update Component Item name */
1235:
1236: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1237: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1238: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1239: WHERE mvl1.inventory_item_id = BRDI.component_item_id
1240: AND mvl1.organization_id = BRDI.organization_id)
1241: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1242: AND change_notice is null --added for bug 9673701

Line 1252: FROM mtl_system_items MKFV

1248: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
1249: OR ( p_batch_id = BRDI.batch_id )
1250: )
1251: AND exists (SELECT 'x'
1252: FROM mtl_system_items MKFV
1253: WHERE MKFV.inventory_item_id = BRDI.component_item_id
1254: AND MKFV.organization_id = BRDI.organization_id);
1255:
1256:

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

1489: /* Update Assembly Item name */
1490:
1491: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1492: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1493: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1494: WHERE mvl1.inventory_item_id = BSCI.assembly_item_id
1495: AND mvl1.organization_id = BSCI.organization_id)
1496: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1497: AND change_notice is null --added for bug 9673701

Line 1507: FROM mtl_system_items MKFV

1503: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
1504: OR ( p_batch_id = BSCI.batch_id )
1505: )
1506: AND exists (SELECT 'x'
1507: FROM mtl_system_items MKFV
1508: WHERE MKFV.inventory_item_id = BSCI.assembly_item_id
1509: AND MKFV.organization_id = BSCI.organization_id);
1510:
1511:

Line 1517: FROM MTL_SYSTEM_ITEMS_KFV mvl1

1513: /* Update Component Item name */
1514:
1515: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1516: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1517: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1518: WHERE mvl1.inventory_item_id = BSCI.component_item_id
1519: AND mvl1.organization_id = BSCI.organization_id)
1520: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1521: AND change_notice is null --added for bug 9673701

Line 1531: FROM mtl_system_items MKFV

1527: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
1528: OR ( p_batch_id = BSCI.batch_id )
1529: )
1530: AND exists (SELECT 'x'
1531: FROM mtl_system_items MKFV
1532: WHERE MKFV.inventory_item_id = BSCI.component_item_id
1533: AND MKFV.organization_id = BSCI.organization_id);
1534:
1535:

Line 1541: FROM MTL_SYSTEM_ITEMS_KFV mvl1

1537: /* Update Substitute Component name if Id is given */
1538:
1539: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1540: SET SUBSTITUTE_COMP_NUMBER = (SELECT CONCATENATED_SEGMENTS
1541: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1542: WHERE mvl1.inventory_item_id = BSCI.SUBSTITUTE_COMPONENT_ID
1543: and mvl1.organization_id = BSCI.organization_id)
1544: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1545: AND change_notice is null --added for bug 9673701

Line 1555: FROM mtl_system_items MKFV

1551: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
1552: OR ( p_batch_id = BSCI.batch_id )
1553: )
1554: AND exists (SELECT 'x'
1555: FROM mtl_system_items MKFV
1556: WHERE MKFV.inventory_item_id = BSCI.substitute_component_id
1557: AND MKFV.organization_id = BSCI.organization_id);
1558:
1559:

Line 1566: FROM MTL_SYSTEM_ITEMS_KFV mvl1

1562: /* Update new Substitute Component name if Id is given */
1563:
1564: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1565: SET NEW_SUB_COMP_NUMBER = (SELECT CONCATENATED_SEGMENTS
1566: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1567: WHERE mvl1.inventory_item_id = BSCI.NEW_SUB_COMP_ID
1568: and mvl1.organization_id = BSCI.organization_id)
1569: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1570: AND change_notice is null --added for bug 9673701

Line 1580: FROM mtl_system_items MKFV

1576: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
1577: OR ( p_batch_id = BSCI.batch_id )
1578: )
1579: AND exists (SELECT 'x'
1580: FROM mtl_system_items MKFV
1581: WHERE MKFV.inventory_item_id = BSCI.new_sub_comp_id
1582: AND MKFV.organization_id = BSCI.organization_id);
1583:
1584: stmt_num := 9;

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

1813: /* Update Assembly Item name */
1814:
1815: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1816: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1817: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1818: WHERE mvl1.inventory_item_id = BCOI.assembly_item_id
1819: and mvl1.organization_id = BCOI.organization_id)
1820: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1821: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1830: FROM mtl_system_items MKFV

1826: ( (p_batch_id IS NULL) AND (BCOI.batch_id IS NULL) )
1827: OR ( p_batch_id = BCOI.batch_id )
1828: )
1829: AND exists (SELECT 'x'
1830: FROM mtl_system_items MKFV
1831: WHERE MKFV.inventory_item_id = BCOI.assembly_item_id
1832: AND MKFV.organization_id = BCOI.organization_id);
1833:
1834:

Line 1840: FROM MTL_SYSTEM_ITEMS_KFV mvl1

1836: /* Update Component Item name */
1837:
1838: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1839: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1840: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1841: WHERE mvl1.inventory_item_id = BCOI.component_item_id
1842: and mvl1.organization_id = BCOI.organization_id)
1843: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1844: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1853: FROM mtl_system_items MKFV

1849: ( (p_batch_id IS NULL) AND (BCOI.batch_id IS NULL) )
1850: OR ( p_batch_id = BCOI.batch_id )
1851: )
1852: AND exists (SELECT 'x'
1853: FROM mtl_system_items MKFV
1854: WHERE MKFV.inventory_item_id = BCOI.component_item_id
1855: AND MKFV.organization_id = BCOI.organization_id);
1856:
1857:

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

2021: /* Update Assembly Item name */
2022:
2023: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
2024: SET item_number = (SELECT concatenated_segments
2025: FROM MTL_SYSTEM_ITEMS_KFV mvl1
2026: WHERE mvl1.inventory_item_id = MIRI.inventory_item_id
2027: and mvl1.organization_id = MIRI.organization_id)
2028: WHERE process_flag = 1
2029: AND change_notice is null --added for bug 9673701

Line 2035: FROM mtl_system_items mvl2

2031: AND inventory_item_id is not null
2032: AND organization_id is not null
2033: AND MIRI.set_process_id = l_set_process_id
2034: AND exists (SELECT 'x'
2035: FROM mtl_system_items mvl2
2036: WHERE mvl2.inventory_item_id = MIRI.inventory_item_id
2037: and mvl2.organization_id = MIRI.organization_id);
2038:
2039:

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

2283:
2284: /* Update the Assembly_item_number */
2285: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2286: SET assembly_item_number = (SELECT concatenated_segments
2287: FROM mtl_system_items_kfv MKFV
2288: WHERE MKFV.inventory_item_id = BICI.Assembly_item_id
2289: AND MKFV.organization_id = BICI.organization_id)
2290: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2291: AND upper(transaction_type) in (G_Delete, G_Update, G_Create,G_NoOp)

Line 2300: FROM mtl_system_items MKFV2

2296: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2297: OR ( p_batch_id = BICI.batch_id )
2298: )
2299: AND exists (SELECT 'x'
2300: FROM mtl_system_items MKFV2
2301: WHERE MKFV2.inventory_item_id = BICI.Assembly_item_id
2302: AND MKFV2.organization_id = BICI.organization_id);
2303:
2304:

Line 2309: FROM mtl_system_items_kfv mvll

2305:
2306: /* Update the Assembly_item_id */
2307: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2308: SET Assembly_item_id = (SELECT inventory_item_id
2309: FROM mtl_system_items_kfv mvll
2310: WHERE mvll.concatenated_segments = BICI.Assembly_item_number
2311: AND mvll.organization_id = BICI.organization_id)
2312: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2313: AND upper(transaction_type) in (G_Delete, G_Update, G_Create,G_NoOp)

Line 2326: FROM mtl_system_items_kfv mvll

2322:
2323: /* Update component_item_number */
2324: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2325: SET component_item_number = (SELECT concatenated_segments
2326: FROM mtl_system_items_kfv mvll
2327: WHERE mvll.inventory_item_id = BICI.Component_item_id
2328: AND mvll.organization_id = BICI.organization_id)
2329: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2330: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)

Line 2339: FROM mtl_system_items MKFV

2335: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2336: OR ( p_batch_id = BICI.batch_id )
2337: )
2338: AND exists (SELECT 'x'
2339: FROM mtl_system_items MKFV
2340: WHERE MKFV.inventory_item_id = BICI.Component_item_id
2341: AND MKFV.organization_id = BICI.organization_id);
2342:
2343: /* Update the component_item_id */

Line 2346: FROM mtl_system_items_kfv mvll

2342:
2343: /* Update the component_item_id */
2344: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2345: SET component_item_id = (SELECT inventory_item_id
2346: FROM mtl_system_items_kfv mvll
2347: WHERE mvll.concatenated_segments = BICI.Component_item_number
2348: AND mvll.organization_id = BICI.organization_id)
2349: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2350: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)

Line 2451: FROM mtl_system_items_kfv mvll

2447:
2448: /* Update the From_end_item_id */
2449: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2450: SET From_End_Item_id = (SELECT inventory_item_id
2451: FROM mtl_system_items_kfv mvll
2452: WHERE mvll.concatenated_segments = BICI.From_End_Item
2453: AND mvll.organization_id = BICI.organization_id)
2454: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2455: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)

Line 2464: FROM mtl_system_items_kfv mvll2

2460: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2461: OR ( p_batch_id = BICI.batch_id )
2462: )
2463: AND exists (SELECT 'x'
2464: FROM mtl_system_items_kfv mvll2
2465: WHERE mvll2.concatenated_segments = BICI.From_End_Item
2466: AND mvll2.organization_id = BICI.organization_id);
2467:
2468: /* Update the From_end_item_rev_id */

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

2684: /* Update Assembly Item name */
2685:
2686: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2687: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
2688: FROM MTL_SYSTEM_ITEMS_KFV mvl1
2689: WHERE mvl1.inventory_item_id = BRDI.assembly_item_id
2690: AND mvl1.organization_id = BRDI.organization_id)
2691: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2692: AND assembly_item_id is not null

Line 2700: FROM mtl_system_items mvl12

2696: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
2697: OR ( p_batch_id = BRDI.batch_id )
2698: )
2699: AND exists (SELECT 'x'
2700: FROM mtl_system_items mvl12
2701: WHERE mvl12.inventory_item_id = BRDI.assembly_item_id
2702: AND mvl12.organization_id = BRDI.organization_id);
2703:
2704: /* Update the Assembly_item_id */

Line 2707: FROM mtl_system_items_kfv mvll

2703:
2704: /* Update the Assembly_item_id */
2705: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2706: SET Assembly_item_id = (SELECT inventory_item_id
2707: FROM mtl_system_items_kfv mvll
2708: WHERE mvll.concatenated_segments = BRDI.Assembly_item_number
2709: AND mvll.organization_id = BRDI.organization_id)
2710: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2711: AND Assembly_item_number is not null

Line 2723: FROM MTL_SYSTEM_ITEMS_KFV mvl1

2719:
2720: /* Update Component Item name */
2721: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2722: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
2723: FROM MTL_SYSTEM_ITEMS_KFV mvl1
2724: WHERE mvl1.inventory_item_id = BRDI.component_item_id
2725: AND mvl1.organization_id = BRDI.organization_id)
2726: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2727: AND COMPONENT_ITEM_ID is not null

Line 2735: FROM mtl_system_items mvl12

2731: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
2732: OR ( p_batch_id = BRDI.batch_id )
2733: )
2734: AND exists (SELECT 'x'
2735: FROM mtl_system_items mvl12
2736: WHERE mvl12.inventory_item_id = BRDI.component_item_id
2737: AND mvl12.organization_id = BRDI.organization_id);
2738:
2739:

Line 2743: FROM mtl_system_items_kfv mvll

2739:
2740: /* Update the Component_item_id */
2741: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2742: SET Component_item_id = (SELECT inventory_item_id
2743: FROM mtl_system_items_kfv mvll
2744: WHERE mvll.concatenated_segments = BRDI.Component_item_number
2745: AND mvll.organization_id = BRDI.organization_id)
2746: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2747: AND Component_item_number is not null

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

2950: /* Update Assembly Item name */
2951:
2952: UPDATE bom_sub_comps_interface BSCI
2953: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
2954: FROM MTL_SYSTEM_ITEMS_KFV mvl1
2955: WHERE mvl1.inventory_item_id = BSCI.assembly_item_id
2956: AND mvl1.organization_id = BSCI.organization_id)
2957: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2958: AND assembly_item_id is not null

Line 2966: FROM mtl_system_items mvl12

2962: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
2963: OR ( p_batch_id = BSCI.batch_id )
2964: )
2965: AND exists (SELECT 'x'
2966: FROM mtl_system_items mvl12
2967: WHERE mvl12.inventory_item_id = BSCI.assembly_item_id
2968: AND mvl12.organization_id = BSCI.organization_id);
2969:
2970: /* Update the Assembly_item_id */

Line 2973: FROM mtl_system_items_kfv mvll

2969:
2970: /* Update the Assembly_item_id */
2971: UPDATE bom_sub_comps_interface BSCI
2972: SET Assembly_item_id = (SELECT inventory_item_id
2973: FROM mtl_system_items_kfv mvll
2974: WHERE mvll.concatenated_segments = BSCI.Assembly_item_number
2975: AND mvll.organization_id = BSCI.organization_id)
2976: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2977: AND Assembly_item_number is not null

Line 2989: FROM MTL_SYSTEM_ITEMS_KFV mvl1

2985:
2986: /* Update Component Item name */
2987: UPDATE bom_sub_comps_interface BSCI
2988: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
2989: FROM MTL_SYSTEM_ITEMS_KFV mvl1
2990: WHERE mvl1.inventory_item_id = BSCI.component_item_id
2991: AND mvl1.organization_id = BSCI.organization_id)
2992: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2993: AND COMPONENT_ITEM_ID is not null

Line 3001: FROM mtl_system_items mvl12

2997: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
2998: OR ( p_batch_id = BSCI.batch_id )
2999: )
3000: AND exists (SELECT 'x'
3001: FROM mtl_system_items mvl12
3002: WHERE mvl12.inventory_item_id = BSCI.component_item_id
3003: AND mvl12.organization_id = BSCI.organization_id);
3004:
3005:

Line 3009: FROM mtl_system_items_kfv mvll

3005:
3006: /* Update the Component_item_id */
3007: UPDATE bom_sub_comps_interface BSCI
3008: SET Component_item_id = (SELECT inventory_item_id
3009: FROM mtl_system_items_kfv mvll
3010: WHERE mvll.concatenated_segments = BSCI.Component_item_number
3011: AND mvll.organization_id = BSCI.organization_id)
3012: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
3013: AND Component_item_number is not null

Line 3063: FROM MTL_SYSTEM_ITEMS_KFV mvl1

3059:
3060:
3061: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
3062: SET SUBSTITUTE_COMP_NUMBER = (SELECT concatenated_segments
3063: FROM MTL_SYSTEM_ITEMS_KFV mvl1
3064: WHERE mvl1.inventory_item_id = BSCI.SUBSTITUTE_COMPONENT_ID
3065: and mvl1.organization_id = BSCI.organization_id)
3066: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
3067: AND upper(transaction_type) in (G_Create, G_Delete, G_Update,'SYNC')

Line 3076: FROM mtl_system_items mvl12

3072: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
3073: OR ( p_batch_id = BSCI.batch_id )
3074: )
3075: AND exists (SELECT 'x'
3076: FROM mtl_system_items mvl12
3077: WHERE mvl12.inventory_item_id = BSCI.SUBSTITUTE_COMPONENT_ID
3078: AND mvl12.organization_id = BSCI.organization_id);
3079:
3080: --Update Sub Comp Number If id is given

Line 3084: FROM MTL_SYSTEM_ITEMS_KFV mvl1

3080: --Update Sub Comp Number If id is given
3081:
3082: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
3083: SET SUBSTITUTE_COMPONENT_ID = (SELECT inventory_item_id
3084: FROM MTL_SYSTEM_ITEMS_KFV mvl1
3085: WHERE mvl1.concatenated_segments = BSCI.SUBSTITUTE_COMP_NUMBER
3086: and mvl1.organization_id = BSCI.organization_id)
3087: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
3088: AND upper(transaction_type) in (G_Create, G_Delete, G_Update,'SYNC')

Line 3102: FROM MTL_SYSTEM_ITEMS_KFV mvl1

3098: --Update New Sub Comp Number
3099:
3100: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
3101: SET NEW_SUB_COMP_NUMBER = (SELECT CONCATENATED_SEGMENTS
3102: FROM MTL_SYSTEM_ITEMS_KFV mvl1
3103: WHERE mvl1.inventory_item_id = BSCI.NEW_SUB_COMP_ID
3104: and mvl1.organization_id = BSCI.organization_id)
3105: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
3106: AND upper(transaction_type) in (G_Create, G_Delete, G_Update,'SYNC')

Line 3115: FROM mtl_system_items mvl12

3111: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
3112: OR ( p_batch_id = BSCI.batch_id )
3113: )
3114: AND exists (SELECT 'x'
3115: FROM mtl_system_items mvl12
3116: WHERE mvl12.inventory_item_id = BSCI.NEW_SUB_COMP_ID
3117: and mvl12.organization_id = BSCI.organization_id);
3118:
3119:

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