APPS.CSP_SUPPLY_DEMAND_PVT dependencies on WIP_DISCRETE_JOBS

Line 638: from wip_discrete_jobs wdj,

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

Line 677: from wip_discrete_jobs wdj,

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

Line 709: from wip_discrete_jobs wdj,

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

Line 740: from wip_discrete_jobs wdj,

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