APPS.WIP_WIPLBPER_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 70

                                          (SELECT 1 FROM WIP_DISCRETE_JOBS WDJ
                                          WHERE WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
                                          AND WDJ.ORGANIZATION_ID = WE.ORGANIZATION_ID
                                          AND TRUNC(WDJ.DATE_RELEASED) <= TO_DATE(''' || TO_CHAR(P_TO_DATE
                              ,'YYYYMMDD') || ''',''YYYYMMDD'') AND NVL(TRUNC(WDJ.DATE_CLOSED),TO_DATE(''' || TO_CHAR(P_FROM_DATE
                              ,'YYYYMMDD') || ''',''YYYYMMDD'')) >= TO_DATE(''' || TO_CHAR(P_FROM_DATE
                              ,'YYYYMMDD') || ''',''YYYYMMDD'')))
                                          OR (WE.ENTITY_TYPE = 2
                                          AND EXISTS
                                          (SELECT 1 FROM WIP_REPETITIVE_SCHEDULES WRS1
                                          WHERE WRS1.ORGANIZATION_ID = WE.ORGANIZATION_ID
                                          AND WRS1.REPETITIVE_SCHEDULE_ID =
                                          WOP.REPETITIVE_SCHEDULE_ID
                                        AND TRUNC(WRS1.DATE_RELEASED) <= TO_DATE(''' || TO_CHAR(P_TO_DATE
                              ,'YYYYMMDD') || ''',''YYYYMMDD'') AND NVL(TRUNC(WRS1.DATE_CLOSED),TO_DATE(''' || TO_CHAR(P_FROM_DATE
                              ,'YYYYMMDD') || ''',''YYYYMMDD'')) >= TO_DATE(''' || TO_CHAR(P_FROM_DATE
                              ,'YYYYMMDD') || ''',''YYYYMMDD''))))';

Line: 90

                                           (SELECT 1 FROM WIP_DISCRETE_JOBS WDJ
                                           WHERE WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
                                           AND WDJ.ORGANIZATION_ID = WE.ORGANIZATION_ID
                                           AND WDJ.DATE_RELEASED IS NOT NULL
                                           AND NVL(TRUNC(WDJ.DATE_CLOSED),TO_DATE(''' || TO_CHAR(P_FROM_DATE
                              ,'YYYYMMDD') || ''',''YYYYMMDD'')) >= TO_DATE(''' || TO_CHAR(P_FROM_DATE
                              ,'YYYYMMDD') || ''',''YYYYMMDD'')))
                                           OR (WE.ENTITY_TYPE = 2
                                           AND EXISTS
                                           (SELECT 1 FROM WIP_REPETITIVE_SCHEDULES WRS1
                                           WHERE WRS1.ORGANIZATION_ID = WE.ORGANIZATION_ID
                                           AND WRS1.REPETITIVE_SCHEDULE_ID =
                                                WOP.REPETITIVE_SCHEDULE_ID
                                           AND WRS1.DATE_RELEASED IS NOT NULL
                                           AND NVL(TRUNC(WRS1.DATE_CLOSED),TO_DATE(''' || TO_CHAR(P_FROM_DATE
                              ,'YYYYMMDD') || ''',''YYYYMMDD'')) >= TO_DATE(''' || TO_CHAR(P_FROM_DATE
                              ,'YYYYMMDD') || ''',''YYYYMMDD''))))';

Line: 112

                                           (SELECT 1 FROM WIP_DISCRETE_JOBS WDJ
                                           WHERE WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
                                           AND WDJ.ORGANIZATION_ID = WE.ORGANIZATION_ID
                                          AND TRUNC(WDJ.DATE_RELEASED) <= TO_DATE(''' || TO_CHAR(P_TO_DATE
                              ,'YYYYMMDD') || ''',''YYYYMMDD'')))
                                           OR (WE.ENTITY_TYPE = 2
                                           AND EXISTS
                                           (SELECT 1 FROM WIP_REPETITIVE_SCHEDULES WRS1
                                           WHERE WRS1.ORGANIZATION_ID = WE.ORGANIZATION_ID
                                           AND WRS1.REPETITIVE_SCHEDULE_ID =
                                                 WOP.REPETITIVE_SCHEDULE_ID
                                       AND TRUNC(WRS1.DATE_RELEASED) <= TO_DATE(''' || TO_CHAR(P_TO_DATE
                              ,'YYYYMMDD') || ''',''YYYYMMDD''))))';

Line: 210

                                                 (SELECT 1 FROM WIP_FLOW_SCHEDULES WFS2
                                                  WHERE WFS2.WIP_ENTITY_ID = WF.WIP_ENTITY_ID
                                                  AND WFS2.ORGANIZATION_ID = WF.ORGANIZATION_ID
                                                  AND TRUNC(WFS2.SCHEDULED_START_DATE) <= TO_DATE(''' || TO_CHAR(P_TO_DATE
                              ,'YYYYMMDD') || ''',''YYYYMMDD'') AND NVL(TRUNC(WFS2.SCHEDULED_COMPLETION_DATE),TO_DATE(''' || TO_CHAR(P_FROM_DATE
                              ,'YYYYMMDD') || ''',''YYYYMMDD'')) >= TO_DATE(''' || TO_CHAR(P_FROM_DATE
                              ,'YYYYMMDD') || ''',''YYYYMMDD'')))';

Line: 219

                                           (SELECT 1 FROM WIP_FLOW_SCHEDULES WFS2
                                           WHERE WFS2.ORGANIZATION_ID = WF.ORGANIZATION_ID
                                           AND WFS2.WIP_ENTITY_ID =  WF.WIP_ENTITY_ID
                                           AND WFS2.SCHEDULED_START_DATE IS NOT NULL
                                           AND NVL(TRUNC(WFS2.SCHEDULED_COMPLETION_DATE),TO_DATE(''' || TO_CHAR(P_FROM_DATE
                              ,'YYYYMMDD') || ''',''YYYYMMDD'')) >= TO_DATE(''' || TO_CHAR(P_FROM_DATE
                              ,'YYYYMMDD') || ''',''YYYYMMDD'')))';

Line: 230

                                           (SELECT 1 FROM WIP_FLOW_SCHEDULES WFS2
                                           WHERE WFS2.ORGANIZATION_ID = WF.ORGANIZATION_ID
                                           AND WFS2.WIP_ENTITY_ID = WF.WIP_ENTITY_ID
                                           AND TRUNC(WFS2.SCHEDULED_START_DATE) <= TO_DATE(''' || TO_CHAR(P_TO_DATE
                              ,'YYYYMMDD') || ''',''YYYYMMDD'')))';