DBA Data[Home] [Help]

APPS.CSTPPBBS dependencies on WIP_DISCRETE_JOBS

Line 642: FROM wip_discrete_jobs wdj

638: AND wppb.wip_entity_id = we.wip_entity_id
639: AND (
640: ( we.entity_type IN (1,3) AND EXISTS (
641: SELECT 'X'
642: FROM wip_discrete_jobs wdj
643: WHERE
644: wdj.wip_entity_id = wppb.wip_entity_id AND
645: NVL(wdj.date_closed, l_current_start_date) >= l_current_start_date))
646: OR (we.entity_type = 4 AND EXISTS (

Line 719: FROM wip_discrete_jobs wdj

715: AND wprocd.wip_entity_id = we.wip_entity_id
716: AND (
717: ( we.entity_type IN (1,3) AND EXISTS (
718: SELECT 'X'
719: FROM wip_discrete_jobs wdj
720: WHERE
721: wdj.wip_entity_id = wprocd.wip_entity_id AND
722: NVL(wdj.date_closed, l_current_start_date) >= l_current_start_date))
723: OR (we.entity_type = 2 AND EXISTS (