DBA Data[Home] [Help]

APPS.CSP_EXCESS_PARTS_PVT dependencies on WIP_REPETITIVE_SCHEDULES

Line 1753: from wip_repetitive_schedules r, wip_requirement_operations o

1749: -- Demand Qty to be added for a released repetitve schedule
1750: -- Bug#691471
1751: select sum(o.required_quantity - o.quantity_issued)
1752: into qty
1753: from wip_repetitive_schedules r, wip_requirement_operations o
1754: where o.wip_entity_id = r.wip_entity_id
1755: and o.organization_id = r.organization_id
1756: and r.organization_id = p_organization_id
1757: and o.inventory_item_id = p_inventory_item_id