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