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_KFV

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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')