APPS.INV_MINMAX_PVT dependencies on WIP_DISCRETE_JOBS

Line 1250: FROM wip_discrete_jobs

1246: SELECT sum(NVL(start_quantity,0)
1247: - NVL(quantity_completed,0)
1248: - NVL(quantity_scrapped,0))
1249: INTO l_qty
1250: FROM wip_discrete_jobs
1251: WHERE organization_id = p_org_id
1252: AND primary_item_id = p_item_id
1253: AND job_type in (1,3)
1254: AND status_type IN (1,3,4,6)

Line 1261: print_debug('Supply from WIP discrete jobs: ' || to_char(l_qty)

1257: AND (NVL(start_quantity,0) - NVL(quantity_completed,0)
1258: - NVL(quantity_scrapped,0)) > 0;
1259:
1260: IF G_TRACE_ON = 1 THEN
1261: print_debug('Supply from WIP discrete jobs: ' || to_char(l_qty)
1262: , 'get_supply_qty'
1263: , 9);
1264: END IF;
1265: l_total := l_total + NVL(l_qty,0);

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