DBA Data[Home] [Help]

APPS.CSP_EXCESS_PARTS_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1858: from wip_discrete_jobs d, wip_requirement_operations o

1854: if (p_net_wip = 1 and p_planning_level = 1)
1855: then
1856: select sum(o.required_quantity - o.quantity_issued)
1857: into qty
1858: from wip_discrete_jobs d, wip_requirement_operations o
1859: where o.wip_entity_id = d.wip_entity_id
1860: and o.organization_id = d.organization_id
1861: and d.organization_id = p_organization_id
1862: and o.inventory_item_id = p_inventory_item_id

Line 1874: from wip_repetitive_schedules r, wip_requirement_operations o

1870: -- Demand Qty to be added for a released repetitve schedule
1871: -- Bug#691471
1872: select sum(o.required_quantity - o.quantity_issued)
1873: into qty
1874: from wip_repetitive_schedules r, wip_requirement_operations o
1875: where o.wip_entity_id = r.wip_entity_id
1876: and o.organization_id = r.organization_id
1877: and r.organization_id = p_organization_id
1878: and o.inventory_item_id = p_inventory_item_id