DBA Data[Home] [Help]

APPS.MRP_SOURCING_API_PK dependencies on MTL_MATERIAL_TRANSACTIONS

Line 597: from mtl_material_transactions

593: IF (arg_source_org = arg_org_id) THEN
594:
595: select NVL(sum(PRIMARY_QUANTITY),0)
596: into x_total_alloc_qty
597: from mtl_material_transactions
598: where
599: inventory_item_id = arg_item_id
600: and ORGANIZATION_ID = arg_org_id
601: and transaction_action_id in (30, 31, 32 )