APPS.CSP_SUPPLY_DEMAND_PVT dependencies on WIP_DISCRETE_JOBS

Line 639: from wip_discrete_jobs wdj,

635: csi.secondary_inventory_name,
636: cpp.planning_parameters_id,
637: cpp.level_id,
638: sum(start_quantity - nvl(quantity_completed,0) - nvl(quantity_scrapped, 0))
639: from wip_discrete_jobs wdj,
640: wip_entities we,
641: csp_sec_inventories csi,
642: csp_planning_parameters cpp
643: where wdj.status_type = 3

Line 678: from wip_discrete_jobs wdj,

674: cpp.secondary_inventory,
675: cpp.planning_parameters_id,
676: cpp.level_id,
677: sum(start_quantity - nvl(quantity_completed,0) - nvl(quantity_scrapped, 0))
678: from wip_discrete_jobs wdj,
679: wip_entities we,
680: csp_planning_parameters cpp
681: where wdj.status_type = 3
682: and we.wip_entity_id = wdj.wip_entity_id

Line 710: from wip_discrete_jobs wdj,

706: wdj.organization_id,
707: cpp.planning_parameters_id,
708: cpp.level_id,
709: sum(start_quantity - nvl(quantity_completed,0) - nvl(quantity_scrapped, 0))
710: from wip_discrete_jobs wdj,
711: wip_entities we,
712: csp_planning_parameters cpp
713: where wdj.status_type = 3
714: and we.wip_entity_id = wdj.wip_entity_id

Line 741: from wip_discrete_jobs wdj,

737: wdj.organization_id,
738: cpp.planning_parameters_id,
739: cpp.level_id,
740: sum(start_quantity - nvl(quantity_completed,0) - nvl(quantity_scrapped, 0))
741: from wip_discrete_jobs wdj,
742: wip_entities we,
743: csp_planning_parameters cpp
744: where wdj.status_type = 3
745: and we.wip_entity_id = wdj.wip_entity_id