APPS.RLM_RLMSCHRL_XMLP_PKG SQL Statements

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

Line: 6

    SELECT
      CUST_ACCT.ACCOUNT_NUMBER
    INTO CNUM
    FROM
      HZ_PARTIES PARTY,
      HZ_CUST_ACCOUNTS CUST_ACCT
    WHERE PARTY.PARTY_ID = CUST_ACCT.PARTY_ID
      AND CUST_ACCT.CUST_ACCOUNT_ID = CUSTOMER_ID;

Line: 26

      SELECT
        ORGANIZATION_CODE
      INTO CODE
      FROM
        ORG_ORGANIZATION_DEFINITIONS
      WHERE ORGANIZATION_ID = SHIP_FROM_ORG_ID;

Line: 47

      SELECT
        ECE_TP_LOCATION_CODE
      INTO LCODE
      FROM
        HZ_CUST_ACCT_SITES
      WHERE CUST_ACCT_SITE_ID = SHIP_TO_ADDRESS_ID;

Line: 69

      SELECT
        CUSTOMER_ITEM_NUMBER
      INTO CNUM
      FROM
        MTL_CUSTOMER_ITEMS
      WHERE CUSTOMER_ITEM_ID = CF_CUST_ITEM_NUMFORMULA.CUSTOMER_ITEM_ID
        AND CUSTOMER_ID = CF_CUST_ITEM_NUMFORMULA.CUSTOMER_ID;

Line: 107

      SELECT
        SCHEDULE_REFERENCE_NUM
      FROM
        RLM_SCHEDULE_HEADERS_ALL
      WHERE HEADER_ID = P_HEADER_ID;

Line: 113

      SELECT
        SCHEDULE_REFERENCE_NUM
      FROM
        RLM_INTERFACE_HEADERS_ALL
      WHERE HEADER_ID = P_HEADER_ID;

Line: 274

      SELECT
        SUBSTRB(PARTY.PARTY_NAME
               ,1
               ,50)
      INTO CNAME
      FROM
        HZ_PARTIES PARTY
      WHERE PARTY.PARTY_ID = (
        SELECT
          CUST_ACCT.PARTY_ID
        FROM
          HZ_CUST_ACCOUNTS CUST_ACCT
        WHERE CUST_ACCT.CUST_ACCOUNT_ID = P_CUSTOMER );

Line: 292

      SELECT
        ORGANIZATION_CODE
      INTO ORGCODE
      FROM
        ORG_ORGANIZATION_DEFINITIONS
      WHERE ORGANIZATION_ID = P_SHIP_FROM;

Line: 303

      SELECT
        ECE_TP_LOCATION_CODE
      INTO LCODE
      FROM
        HZ_CUST_ACCT_SITES
      WHERE CUST_ACCT_SITE_ID = P_SHIP_TO;

Line: 314

      SELECT
        MEANING
      INTO STYPE
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_TYPE'
        AND LOOKUP_CODE = P_SCHEDULE_TYPE;

Line: 326

      SELECT
        MEANING
      INTO SPURPOSE
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_PURPOSE'
        AND LOOKUP_CODE = P_SCHEDULE_PURPOSE;

Line: 338

      SELECT
        MEANING
      INTO PSTATUS
      FROM
        FND_LOOKUP_VALUES_VL FLV
      WHERE FLV.LOOKUP_TYPE = 'RLM_PROCESS_STATUS'
        AND FLV.LOOKUP_CODE = P_PROCESS_STATUS;

Line: 372

      SELECT
        MEANING
      INTO TEST_INDICATOR
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_CODE = 'Y'
        AND LOOKUP_TYPE = 'YES_NO';

Line: 380

      SELECT
        MEANING
      INTO TEST_INDICATOR
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_CODE = 'N'
        AND LOOKUP_TYPE = 'YES_NO';

Line: 397

    SELECT
      DESCRIPTION
    INTO SDPDESC
    FROM
      RLM_SHIP_DELIVERY_CODES
    WHERE SHIP_DELIVERY_RULE_NAME = SHIP_DEL_PATTERN_EXT;

Line: 413

    SELECT
      CONCATENATED_SEGMENTS
    INTO CONC_SEG
    FROM
      MTL_SYSTEM_ITEMS_KFV MSI
    WHERE CF_INV_ITEM_CONC_SEGMENTFORMUL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
      AND MSI.ORGANIZATION_ID = SHIP_FROM_ORG_ID;

Line: 432

      SELECT
        ORGANIZATION_CODE
      INTO CODE
      FROM
        ORG_ORGANIZATION_DEFINITIONS
      WHERE ORGANIZATION_ID = SHIP_FROM_ORG_ID1;

Line: 453

      SELECT
        ECE_TP_LOCATION_CODE
      INTO LCODE
      FROM
        HZ_CUST_ACCT_SITES
      WHERE CUST_ACCT_SITE_ID = SHIP_TO_ADDRESS_ID1;

Line: 471

    SELECT
      DESCRIPTION
    INTO SDPDESC
    FROM
      RLM_SHIP_DELIVERY_CODES
    WHERE SHIP_DELIVERY_RULE_NAME = SHIP_DEL_PATTERN_EXT1;

Line: 487

    SELECT
      CONCATENATED_SEGMENTS
    INTO CONC_SEG
    FROM
      MTL_SYSTEM_ITEMS_KFV MSI
    WHERE INVENTORY_ITEM_ID1 = MSI.INVENTORY_ITEM_ID
      AND MSI.ORGANIZATION_ID = SHIP_FROM_ORG_ID1;

Line: 507

      SELECT
        CUSTOMER_ITEM_NUMBER
      INTO CNUM
      FROM
        MTL_CUSTOMER_ITEMS
      WHERE CUSTOMER_ITEM_ID = CUSTOMER_ITEM_ID1
        AND CUSTOMER_ID = CUSTOMER_ID;

Line: 526

    SELECT
      ECE_TP_LOCATION_CODE
    INTO LCODE
    FROM
      HZ_CUST_ACCT_SITES
    WHERE CUST_ACCT_SITE_ID = BILL_TO_ADDRESS_ID;

Line: 541

    SELECT
      ECE_TP_LOCATION_CODE
    INTO LCODE
    FROM
      HZ_CUST_ACCT_SITES
    WHERE CUST_ACCT_SITE_ID = BILL_TO_ADDRESS_ID1;

Line: 557

      SELECT
        MEANING
      INTO SSOURCE
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_SOURCE'
        AND LOOKUP_CODE = 'MANUAL';