DBA Data[Home] [Help]

APPS.CSTPPBBS dependencies on WIP_REPETITIVE_SCHEDULES

Line 656: FROM wip_repetitive_schedules wrs

652: wfs.status IN (1,2) AND
653: NVL(wfs.date_closed, l_current_start_date) >= l_current_start_date))
654: OR (we.entity_type =2 AND EXISTS (
655: SELECT 'X'
656: FROM wip_repetitive_schedules wrs
657: WHERE
658: wrs.wip_entity_id = wppb.wip_entity_id AND
659: wrs.line_id = wppb.line_id AND
660: NVL(wrs.date_closed, l_current_start_date) >= l_current_start_date)));

Line 725: FROM wip_repetitive_schedules wrs

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 (
724: SELECT 'X'
725: FROM wip_repetitive_schedules wrs
726: WHERE
727: wrs.wip_entity_id = wprocd.wip_entity_id AND
728: wrs.line_id = wprocd.line_id AND
729: NVL(wrs.date_closed, l_current_start_date) >= l_current_start_date)));