DBA Data[Home] [Help]

APPS.CSP_SUPPLY_DEMAND_PVT dependencies on WIP_ENTITIES

Line 640: wip_entities we,

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
644: and we.wip_entity_id = wdj.wip_entity_id

Line 679: wip_entities we,

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
683: and we.entity_type <> 6

Line 711: wip_entities we,

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
715: and we.entity_type <> 6

Line 742: wip_entities we,

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
746: and we.entity_type <> 6