APPS.WMS_WMSSCHS1_XMLP_PKG SQL Statements

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

Line: 15

      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: 38

      SELECT
        REQUEST_DATE,
        ACTUAL_START_DATE,
        SAVE_OUTPUT_FLAG,
        PRINTER
      INTO P_REQUEST_DATE,P_ACTUAL_START_DATE,P_SAVE_OUTPUT_FLAG,P_PRINTER
      FROM
        FND_CONCURRENT_REQUESTS
      WHERE REQUEST_ID = P_CONC_REQUEST_ID;

Line: 57

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

Line: 73

    SELECT
      OPERATING_UNIT
    INTO L_MASTER_ORG_ID
    FROM
      ORG_ORGANIZATION_DEFINITIONS
    WHERE ORGANIZATION_ID = P_ORG_ID;

Line: 138

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

Line: 147

      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: 157

    SELECT
      MEANING
    INTO L_VALUE_NO
    FROM
      MFG_LOOKUPS
    WHERE LOOKUP_TYPE = 'SYS_YES_NO'
      AND LOOKUP_CODE = 2;

Line: 164

    SELECT
      MEANING
    INTO L_VALUE_YES
    FROM
      MFG_LOOKUPS
    WHERE LOOKUP_TYPE = 'SYS_YES_NO'
      AND LOOKUP_CODE = 1;

Line: 185

        SELECT
          NAME
        INTO P_SO_TYPE
        FROM
          OE_TRANSACTION_TYPES
        WHERE TRANSACTION_TYPE_ID = P_ORDER_TYPE;

Line: 201

        SELECT
          ORDER_NUMBER
        INTO P_ORDER_NUMBER
        FROM
          OE_ORDER_HEADERS_ALL
        WHERE HEADER_ID = P_ORDER_HEADER_ID;

Line: 215

        SELECT
          LINE_NUMBER || '.' || SHIPMENT_NUMBER || '.' || DECODE(OPTION_NUMBER
                ,NULL
                ,' '
                ,'.' || OPTION_NUMBER)
        INTO P_LINE_NUMBER
        FROM
          OE_ORDER_LINES_ALL
        WHERE HEADER_ID = P_ORDER_HEADER_ID
          AND LINE_ID = P_ORDER_LINE_ID;

Line: 248

      SELECT
        LICENSE_PLATE_NUMBER
      INTO P_LICENSE_PLATE_NUMBER
      FROM
        WMS_LICENSE_PLATE_NUMBERS
      WHERE LPN_ID = LPN_ID_1;

Line: 263

      SELECT
        LICENSE_PLATE_NUMBER
      INTO P_OUTERMOST_LPN
      FROM
        WMS_LICENSE_PLATE_NUMBERS
      WHERE LPN_ID = (
        SELECT
          OUTERMOST_LPN_ID
        FROM
          WMS_LICENSE_PLATE_NUMBERS
        WHERE LPN_ID = LPN_ID_1 );

Line: 283

      SELECT
        PROJECT_NAME
      INTO P_PROJECT_1
      FROM
        PJM_PROJECTS_ORG_V
      WHERE INVENTORY_ORGANIZATION_ID = P_ORG_ID
        AND PROJECT_ID = PROJECT_ID_1;

Line: 300

      SELECT
        TASK_NAME
      INTO P_TASK_1
      FROM
        PJM_TASKS_V
      WHERE PROJECT_ID = PROJECT_ID_1
        AND TASK_ID = TASK_ID_1;

Line: 316

      SELECT
        LOCATION_CODE
      INTO P_SHIP_TO_LOCATION
      FROM
        HR_LOCATIONS
      WHERE LOCATION_ID = SHIP_TO_LOCATION_ID_1;