DBA Data[Home] [Help]

APPS.CSP_EXCESS_PARTS_PVT dependencies on WIP_DISCRETE_JOBS

Line 1737: from wip_discrete_jobs d, wip_requirement_operations o

1733: if (p_net_wip = 1 and p_planning_level = 1)
1734: then
1735: select sum(o.required_quantity - o.quantity_issued)
1736: into qty
1737: from wip_discrete_jobs d, wip_requirement_operations o
1738: where o.wip_entity_id = d.wip_entity_id
1739: and o.organization_id = d.organization_id
1740: and d.organization_id = p_organization_id
1741: and o.inventory_item_id = p_inventory_item_id