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

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

Line 1122: FROM MTL_SYSTEM_ITEMS_KFV mvl1

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

Line 1399: FROM MTL_SYSTEM_ITEMS_KFV mvl1

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

Line 1693: FROM MTL_SYSTEM_ITEMS_KFV mvl1

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

Line 1903: FROM MTL_SYSTEM_ITEMS_KFV mvl1

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