APPS.WSH_WSHRDXCP_XMLP_PKG SQL Statements

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

Line: 11

      CP_LAST_UPDATE_DATE_FROM := to_char(P_LAST_UPDATE_DATE_FROM,C_DATE_FORMAT);

Line: 12

      CP_LAST_UPDATE_DATE_TO := to_char(P_LAST_UPDATE_DATE_TO,C_DATE_FORMAT);

Line: 46

        SELECT
          NAME
        FROM
          HR_ORGANIZATION_UNITS
        WHERE ORGANIZATION_ID = P_ORG_ID;

Line: 109

    P_CREATION_UPDATE_DATE := ' ';

Line: 151

      P_CREATION_UPDATE_DATE := ' and we.creation_date >= :p_creation_date_from ';

Line: 154

      P_CREATION_UPDATE_DATE := P_CREATION_UPDATE_DATE || ' and we.creation_date - ( 86399/86400 ) <= :p_creation_date_to ';

Line: 156

    IF (P_LAST_UPDATE_DATE_FROM IS NOT NULL) THEN
      P_CREATION_UPDATE_DATE := P_CREATION_UPDATE_DATE || ' and we.last_update_date >= :p_last_update_date_from ';

Line: 159

    IF (P_LAST_UPDATE_DATE_TO IS NOT NULL) THEN
      P_CREATION_UPDATE_DATE := P_CREATION_UPDATE_DATE || ' and we.last_update_date - ( 86399/86400 ) <= :p_last_update_date_to ';

Line: 167

         P_DEL_LINES_CONT:= 'UNION select
         --Bug 8800213 :Adding the hint to improve performance
         /*+ leading(wda)*/
         EXCEPTION_ID         --Bug 8800213 indented all columns to left to reduce the dynamic string length
         ,LOGGED_AT_LOCATION_ID
         ,LE.MEANING LOGGING_ENTITY_MEANING
         ,EXCEPTION_NAME
         ,EXCEPTION_LOCATION_ID
         ,MESSAGE
         ,SEV.MEANING SEVERITY_MEANING
         ,MANUALLY_LOGGED
         ,STA.MEANING STATUS_MEANING
         ,we.TRIP_ID
         ,TRIP_NAME
         ,we.TRIP_STOP_ID
         ,we.DELIVERY_ID
         ,DELIVERY_NAME
         ,we.DELIVERY_DETAIL_ID
         ,we.DELIVERY_ASSIGNMENT_ID
         ,we.CONTAINER_NAME
         ,' || P_ITEM_FLEXSQL ||' C_ITEM_FLEXDAT --bug 8800213 placed P_ITEM_FLEXSQL outside string so that its values is appended
         ,we.INVENTORY_ITEM_ID
         ,we.LOT_NUMBER
         -- HW OPM Convergence Project. Commented Sublot
         -- ,we.SUBLOT_NUMBER
         ,we.REVISION
         ,we.SERIAL_NUMBER
         ,UNIT_OF_MEASURE
         ,UNIT_OF_MEASURE2
         ,QUANTITY
         ,QUANTITY2
         ,we.SUBINVENTORY
         ,we.LOCATOR_ID
         ,'|| P_LOCATOR_FLEXSQL  ||' C_LOCATOR_FLEXDAT --bug 8800213 placed  P_LOCATOR_FLEXSQL outside string so that its values is appended
         ,ARRIVAL_DATE
         ,DEPARTURE_DATE
         ,ERROR_MESSAGE
         ,we.CREATION_DATE
         ,we.REQUEST_ID
         ,WND.NAME DEL_NAME
         ,WT.NAME TRP_NAME
          --Bug 8800213 added following columns as main query has these columns.
         ,WSH_WSHRDXCP_XMLP_PKG.c_exception_locationformula(EXCEPTION_LOCATION_ID) C_Exception_Location
         ,WSH_WSHRDXCP_XMLP_PKG.c_logged_locationformula(LOGGED_AT_LOCATION_ID) C_Logged_Location
         ,WSH_WSHRDXCP_XMLP_PKG.cf_container_nameformula(we.CONTAINER_NAME, we.DELIVERY_DETAIL_ID) CF_container_name
         ,WSH_WSHRDXCP_XMLP_PKG.cf_delivery_nameformula(we.DELIVERY_DETAIL_ID, WND.NAME) CF_delivery_name
         ,WSH_WSHRDXCP_XMLP_PKG.CP_delivery_detail_id_p CP_delivery_detail_id';

Line: 263

       	  --Bug 8310786:The following part of query ensures that only exceptions logged against delivery details are selected.
          P_DEL_LINES_CONT_1 := P_DEL_LINES_CONT_1 || ' AND    wda.delivery_id IS NOT NULL
                    AND we.delivery_detail_id = wda.delivery_detail_id
                    AND    we.status <> ''CLOSED''    ';

Line: 358

      SELECT
        CONTAINER_NAME,
        CONTAINER_FLAG
      FROM
        WSH_DELIVERY_DETAILS WDD
      WHERE WDD.DELIVERY_DETAIL_ID = X_DETAIL_ID;

Line: 397

      SELECT
        NAME
      FROM
        WSH_NEW_DELIVERIES WND,
        WSH_DELIVERY_DETAILS WDD,
        WSH_DELIVERY_ASSIGNMENTS_V WDA
      WHERE WDD.DELIVERY_DETAIL_ID = P_DELIVERY_DETAIL_ID
        AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
        AND WDA.DELIVERY_ID = WND.DELIVERY_ID
        AND WND.DELIVERY_TYPE = 'STANDARD';