APPS.WMS_WMSSTCON_XMLP_PKG SQL Statements

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

Line: 16

      SELECT
        CP.USER_CONCURRENT_PROGRAM_NAME
      INTO L_REPORT_NAME
      FROM
        FND_CONCURRENT_PROGRAMS_VL CP,
        FND_CONCURRENT_REQUESTS CR
      WHERE CR.REQUEST_ID = P_CONC_REQUEST_ID
        AND CP.APPLICATION_ID = CR.PROGRAM_APPLICATION_ID
        AND CP.CONCURRENT_PROGRAM_ID = CR.CONCURRENT_PROGRAM_ID;

Line: 44

                   ,'Failed flexsql loc select in before report trigger')*/NULL;

Line: 83

        SELECT
          ORGANIZATION_CODE,
          ORGANIZATION_NAME
        INTO P_ORG_CODE,P_ORG_NAME
        FROM
          ORG_ORGANIZATION_DEFINITIONS
        WHERE ORGANIZATION_ID = P_ORG_ID;

Line: 92

        SELECT
          NAME
        INTO P_TRIP_NAME
        FROM
          WSH_TRIPS
        WHERE TRIP_ID = P_TRIP_ID;

Line: 100

        SELECT
          NAME
        INTO P_DELIVERY_NAME
        FROM
          WSH_NEW_DELIVERIES
        WHERE DELIVERY_ID = P_DELIVERY_ID;

Line: 108

        SELECT
          PARTY.PARTY_NAME,
          PARTY.PARTY_NUMBER
        INTO P_CUSTOMER_NAME,P_CUSTOMER_NUMBER
        FROM
          HZ_PARTIES PARTY,
          HZ_CUST_ACCOUNTS CUST_ACCT
        WHERE CUST_ACCT.CUST_ACCOUNT_ID = P_CUSTOMER_ID
          AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID;

Line: 119

        SELECT
          ORDER_NUMBER
        INTO P_SALES_ORDER
        FROM
          OE_ORDER_HEADERS_ALL
        WHERE HEADER_ID = P_SALES_ORDER_HEADER_ID;

Line: 126

          SELECT
            PARTY.PARTY_NAME,
            PARTY.PARTY_NUMBER
          INTO P_CUSTOMER_NAME,P_CUSTOMER_NUMBER
          FROM
            HZ_PARTIES PARTY,
            HZ_CUST_ACCOUNTS CUST_ACCT,
            OE_ORDER_HEADERS_ALL OEH
          WHERE CUST_ACCT.CUST_ACCOUNT_ID = OEH.SOLD_TO_ORG_ID
            AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
            AND OEH.HEADER_ID = P_SALES_ORDER_HEADER_ID;

Line: 160

      SELECT
        count(SOURCE_HEADER_ID)
      INTO MCOUNT
      FROM
        WSH_DELIVERY_DETAILS
      WHERE DELIVERY_DETAIL_ID in (
        SELECT
          WDA.DELIVERY_DETAIL_ID
        FROM
          WSH_DELIVERY_DETAILS WDD,
          WSH_DELIVERY_ASSIGNMENTS WDA
        WHERE WDD.ORGANIZATION_ID = P_ORG_ID
          AND WDD.LPN_ID = INMULTIPLESOFORMULA.LPN_ID
          AND WDD.DELIVERY_DETAIL_ID = WDA.PARENT_DELIVERY_DETAIL_ID )
        AND SOURCE_CODE = 'OE';

Line: 187

      SELECT
        count(WDA.DELIVERY_ID)
      INTO MCOUNT
      FROM
        WSH_DELIVERY_DETAILS WDD,
        WSH_DELIVERY_ASSIGNMENTS WDA
      WHERE WDD.ORGANIZATION_ID = P_ORG_ID
        AND WDD.LPN_ID = INMULTIPLEDELIVERYFORMULA.LPN_ID
        AND WDD.DELIVERY_DETAIL_ID = WDA.PARENT_DELIVERY_DETAIL_ID;

Line: 208

      SELECT
        count(WTS.TRIP_ID)
      INTO MCOUNT
      FROM
        WSH_DELIVERY_LEGS WDL,
        WSH_TRIP_STOPS WTS
      WHERE WDL.PICK_UP_STOP_ID = WTS.STOP_ID
        AND WDL.DELIVERY_ID in (
        SELECT
          WDA.DELIVERY_ID
        FROM
          WSH_DELIVERY_DETAILS WDD,
          WSH_DELIVERY_ASSIGNMENTS WDA
        WHERE WDD.ORGANIZATION_ID = P_ORG_ID
          AND WDD.LPN_ID = INMULTIPLETRIPFORMULA.LPN_ID
          AND WDD.DELIVERY_DETAIL_ID = WDA.PARENT_DELIVERY_DETAIL_ID );