DBA Data[Home] [Help]

APPS.INV_MINMAX_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 2073: from wip_discrete_jobs d, wip_requirement_operations o

2069: /*4518296*/
2070:
2071: select sum(o.required_quantity - o.quantity_issued)
2072: into qty
2073: from wip_discrete_jobs d, wip_requirement_operations o
2074: where o.wip_entity_id = d.wip_entity_id
2075: and o.organization_id = d.organization_id
2076: and d.organization_id = p_org_id
2077: and o.inventory_item_id = p_item_id

Line 2099: from wip_repetitive_schedules r, wip_requirement_operations o

2095: --
2096: /*4518296*/
2097: select sum(o.required_quantity - o.quantity_issued)
2098: into qty
2099: from wip_repetitive_schedules r, wip_requirement_operations o
2100: where o.wip_entity_id = r.wip_entity_id
2101: and o.repetitive_schedule_id = r.repetitive_schedule_id
2102: and o.organization_id = r.organization_id
2103: and r.organization_id = p_org_id