DBA Data[Home] [Help]

APPS.CSP_MINMAX_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1831: from wip_discrete_jobs d, wip_requirement_operations o

1827: if (p_net_wip = 1 and p_level = 1)
1828: then
1829: select sum(o.required_quantity - o.quantity_issued)
1830: into qty
1831: from wip_discrete_jobs d, wip_requirement_operations o
1832: where o.wip_entity_id = d.wip_entity_id
1833: and o.organization_id = d.organization_id
1834: and d.organization_id = p_org_id
1835: and o.inventory_item_id = p_item_id

Line 1854: from wip_repetitive_schedules r, wip_requirement_operations o

1850: -- Bug#691471
1851: --
1852: select sum(o.required_quantity - o.quantity_issued)
1853: into qty
1854: from wip_repetitive_schedules r, wip_requirement_operations o
1855: where o.wip_entity_id = r.wip_entity_id
1856: and o.repetitive_schedule_id = r.repetitive_schedule_id
1857: and o.organization_id = r.organization_id
1858: and r.organization_id = p_org_id