APPS.CSP_MINMAX_PVT dependencies on WIP_DISCRETE_JOBS

Line 1304: FROM wip_discrete_jobs

1300: SELECT sum(NVL(start_quantity,0)
1301: - NVL(quantity_completed,0)
1302: - NVL(quantity_scrapped,0))
1303: INTO l_qty
1304: FROM wip_discrete_jobs
1305: WHERE organization_id = p_org_id
1306: AND primary_item_id = p_item_id
1307: AND job_type in (1,3)
1308: AND status_type IN (1,3,4,6)

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

1311:
1312: AND (NVL(start_quantity,0) - NVL(quantity_completed,0)
1313: - NVL(quantity_scrapped,0)) > 0;
1314:
1315: print_debug('Supply from WIP discrete jobs: ' || to_char(l_qty)
1316: , 'get_supply_qty'
1317: , 9);
1318: l_total := l_total + NVL(l_qty,0);
1319:

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