APPS.CSTPLCAC dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1406: from mtl_material_transactions mmt

1402: l_prior_completed_qty :=i_txn_qty;
1403: l_stmt_num :=40;
1404: select decode( nvl(sum(mmt.primary_quantity),0),0,i_txn_qty,sum(mmt.primary_quantity))
1405: into l_prior_completed_qty
1406: from mtl_material_transactions mmt
1407: where mmt.transaction_source_type_id=5
1408: and mmt.transaction_action_id in (31,32)
1409: and mmt.transaction_source_id = i_wip_entity_id
1410: and mmt.organization_id = i_org_id