APPS.CST_COSTPROCVALIDATION_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 182: SELECT 1 FROM mtl_secondary_inventories msi

178: WHERE mmt.costed_flag = 'N'
179: AND mmt.transaction_action_id IN (2,3,5,28)
180: AND ( mmt.transfer_transaction_id IS NULL
181: OR NOT EXISTS (
182: SELECT 1 FROM mtl_secondary_inventories msi
183: WHERE msi.secondary_inventory_name = mmt.subinventory_code
184: AND msi.organization_id = mmt.organization_id)
185: OR NOT EXISTS (
186: SELECT 1 FROM mtl_secondary_inventories msi

Line 186: SELECT 1 FROM mtl_secondary_inventories msi

182: SELECT 1 FROM mtl_secondary_inventories msi
183: WHERE msi.secondary_inventory_name = mmt.subinventory_code
184: AND msi.organization_id = mmt.organization_id)
185: OR NOT EXISTS (
186: SELECT 1 FROM mtl_secondary_inventories msi
187: WHERE msi.secondary_inventory_name = mmt.transfer_subinventory
188: AND msi.organization_id = mmt.transfer_organization_id)
189: OR ( mmt.transaction_action_id IN (2,5,28)
190: AND mmt.organization_id <> mmt.transfer_organization_id));

Line 384: FROM mtl_secondary_inventories msi

380: WHERE mmt.costed_flag = 'N'
381: AND mmt.transaction_action_id in (1,27)
382: AND NOT EXISTS
383: (SELECT 1
384: FROM mtl_secondary_inventories msi
385: WHERE msi.organization_id = mmt.organization_id
386: AND msi.secondary_inventory_name = mmt.subinventory_code);
387:
388: l_stmt_num := 130;