DBA Data[Home] [Help]

APPS.INV_MINMAX_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 2063: from wip_discrete_jobs d, wip_requirement_operations o

2059: /*4518296*/
2060:
2061: select sum(o.required_quantity - o.quantity_issued)
2062: into qty
2063: from wip_discrete_jobs d, wip_requirement_operations o
2064: where o.wip_entity_id = d.wip_entity_id
2065: and o.organization_id = d.organization_id
2066: and d.organization_id = p_org_id
2067: and o.inventory_item_id = p_item_id

Line 2089: from wip_repetitive_schedules r, wip_requirement_operations o

2085: --
2086: /*4518296*/
2087: select sum(o.required_quantity - o.quantity_issued)
2088: into qty
2089: from wip_repetitive_schedules r, wip_requirement_operations o
2090: where o.wip_entity_id = r.wip_entity_id
2091: and o.repetitive_schedule_id = r.repetitive_schedule_id
2092: and o.organization_id = r.organization_id
2093: and r.organization_id = p_org_id