APPS.BOM_RTG_OI_UTIL dependencies on MTL_SYSTEM_ITEMS_KFV

Line 133: FROM MTL_SYSTEM_ITEMS_KFV mvl1

129: /* Update Assembly Item name */
130:
131: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
132: SET assembly_item_number = (SELECT concatenated_segments
133: FROM MTL_SYSTEM_ITEMS_KFV mvl1
134: WHERE mvl1.inventory_item_id = BORI.assembly_item_id
135: and mvl1.organization_id = BORI.organization_id)
136: WHERE process_flag = 1
137: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 211: FROM MTL_SYSTEM_ITEMS_KFV mvl1

207: /* Update Assembly Item name */
208:
209: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
210: SET common_item_number = (SELECT concatenated_segments
211: FROM MTL_SYSTEM_ITEMS_KFV mvl1
212: WHERE mvl1.inventory_item_id = BORI.common_assembly_item_id
213: and mvl1.organization_id = BORI.organization_id)
214: WHERE process_flag = 1
215: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 563: FROM MTL_SYSTEM_ITEMS_KFV mvl1

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

Line 1124: FROM MTL_SYSTEM_ITEMS_KFV mvl1

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

Line 1401: FROM MTL_SYSTEM_ITEMS_KFV mvl1

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

Line 1695: FROM MTL_SYSTEM_ITEMS_KFV mvl1

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

Line 1905: FROM MTL_SYSTEM_ITEMS_KFV mvl1

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