DBA Data[Home] [Help]

APPS.CSP_SUPPLY_DEMAND_PVT dependencies on WIP_ENTITIES

Line 639: wip_entities we,

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

Line 678: wip_entities we,

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

Line 710: wip_entities we,

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

Line 741: wip_entities we,

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