APPS.INVPPROC dependencies on MTL_SYSTEM_ITEMS_B

Line 80: from mtl_system_items_b_kfv msk,

76:
77: CURSOR Flex_Exists IS
78: select msi.item_number,msi.organization_id,msi.organization_code,
79: msi.transaction_id,msi.process_flag
80: from mtl_system_items_b_kfv msk,
81: mtl_system_items_interface msi
82: where msi.item_number = msk.concatenated_segments
83: and msk.organization_id = msi.organization_id
84: AND msi.transaction_type = 'CREATE'

Line 245: INSERT INTO MTL_SYSTEM_ITEMS_B

241: END IF;
242: END LOOP;
243: END IF;
244:
245: INSERT INTO MTL_SYSTEM_ITEMS_B
246: (
247: INVENTORY_ITEM_ID,
248: ORGANIZATION_ID,
249: LAST_UPDATE_DATE,

Line 1630: FROM mtl_system_items_b i

1626: AND mic.organization_id = mp.organization_id
1627: AND mic.category_set_id = mdcs.category_set_id )
1628: AND EXISTS
1629: ( SELECT 'x'
1630: FROM mtl_system_items_b i
1631: WHERE
1632: i.inventory_item_id = msi.inventory_item_id
1633: AND i.organization_id = mp.organization_id
1634: );