APPS.CST_COSTPROCVALIDATION_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 188: SELECT 1 FROM mtl_secondary_inventories msi

184: WHERE mmt.costed_flag = 'N'
185: AND mmt.transaction_action_id IN (2,3,5,28)
186: AND ( mmt.transfer_transaction_id IS NULL
187: OR NOT EXISTS (
188: SELECT 1 FROM mtl_secondary_inventories msi
189: WHERE msi.secondary_inventory_name = mmt.subinventory_code
190: AND msi.organization_id = mmt.organization_id)
191: OR NOT EXISTS (
192: SELECT 1 FROM mtl_secondary_inventories msi

Line 192: SELECT 1 FROM mtl_secondary_inventories msi

188: SELECT 1 FROM mtl_secondary_inventories msi
189: WHERE msi.secondary_inventory_name = mmt.subinventory_code
190: AND msi.organization_id = mmt.organization_id)
191: OR NOT EXISTS (
192: SELECT 1 FROM mtl_secondary_inventories msi
193: WHERE msi.secondary_inventory_name = mmt.transfer_subinventory
194: AND msi.organization_id = mmt.transfer_organization_id)
195: OR ( mmt.transaction_action_id IN (2,5,28)
196: AND mmt.organization_id <> mmt.transfer_organization_id));

Line 379: FROM mtl_secondary_inventories msi

375: WHERE mmt.costed_flag = 'N'
376: AND mmt.transaction_action_id in (1,27)
377: AND NOT EXISTS
378: (SELECT 1
379: FROM mtl_secondary_inventories msi
380: WHERE msi.organization_id = mmt.organization_id
381: AND msi.secondary_inventory_name = mmt.subinventory_code);
382:
383: l_stmt_num := 130;