APPS.RLM_RLMDMSIQ_XMLP_PKG SQL Statements

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

Line: 9

      SELECT
        ACCT_SITE.ECE_TP_LOCATION_CODE
      FROM
        HZ_CUST_SITE_USES_ALL CUST_SITE,
        HZ_CUST_ACCT_SITES ACCT_SITE
      WHERE CUST_SITE.SITE_USE_CODE = L_SHIP_TO
        AND ACCT_SITE.STATUS = L_STATUS
        AND CUST_SITE.SITE_USE_ID = NU_SHIP_TO
        AND ACCT_SITE.CUST_ACCT_SITE_ID = CUST_SITE.CUST_ACCT_SITE_ID
        AND CUST_SITE.ORG_ID = ACCT_SITE.ORG_ID;

Line: 20

      SELECT
        PARTY.PARTY_NAME
      FROM
        HZ_PARTIES PARTY,
        HZ_CUST_ACCOUNTS CUST_ACCT
      WHERE PARTY.PARTY_ID = CUST_ACCT.PARTY_ID
        AND CUST_ACCT.CUST_ACCOUNT_ID = V_CUSTOMER_ID;

Line: 28

      SELECT
        ORGANIZATION_CODE
      FROM
        ORG_ORGANIZATION_DEFINITIONS
      WHERE ORGANIZATION_ID = V_SHIP_FROM;

Line: 83

    SELECT
      CUST_ACCT.ACCOUNT_NUMBER
    INTO V_CUST_NUMBER
    FROM
      HZ_CUST_ACCOUNTS CUST_ACCT
    WHERE CUST_ACCT.CUST_ACCOUNT_ID = SOLD_TO_ORG_ID;

Line: 98

    SELECT
      SUBSTRB(PARTY.PARTY_NAME
             ,1
             ,50) CUSTOMER_NAME
    INTO V_CUST_NAME
    FROM
      HZ_CUST_ACCOUNTS CUST_ACCT,
      HZ_PARTIES PARTY
    WHERE CUST_ACCT.CUST_ACCOUNT_ID = SOLD_TO_ORG_ID
      AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID;

Line: 117

    SELECT
      ORGANIZATION_CODE
    INTO V_SHIP_FROM
    FROM
      ORG_ORGANIZATION_DEFINITIONS HRORGS
    WHERE SHIP_FROM_ORG_ID = HRORGS.ORGANIZATION_ID;

Line: 132

    SELECT
      ORGANIZATION_NAME
    INTO V_SHIP_FROM
    FROM
      ORG_ORGANIZATION_DEFINITIONS HRORGS
    WHERE SHIP_FROM_ORG_ID = HRORGS.ORGANIZATION_ID;

Line: 147

    SELECT
      CUSTOMER_ITEM_NUMBER
    INTO V_VALUE
    FROM
      MTL_CUSTOMER_ITEMS MCI
    WHERE ORDERED_ITEM_ID = MCI.CUSTOMER_ITEM_ID;

Line: 162

    SELECT
      CUSTOMER_ITEM_DESC
    INTO V_VALUE
    FROM
      MTL_CUSTOMER_ITEMS MCI
    WHERE ORDERED_ITEM_ID = MCI.CUSTOMER_ITEM_ID;

Line: 178

    SELECT
      CONCATENATED_SEGMENTS
    INTO V_VALUE
    FROM
      MTL_SYSTEM_ITEMS_KFV MSI
    WHERE CONCATENATED_SEGMENTSFORMULA.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
      AND MSI.ORGANIZATION_ID = SHIP_FROM_ORG_ID;

Line: 195

    SELECT
      DESCRIPTION
    INTO V_VALUE
    FROM
      MTL_SYSTEM_ITEMS_KFV MSI
    WHERE  MSI.INVENTORY_ITEM_ID =DESCRIPTIONFORMULA.INVENTORY_ITEM_ID
      AND MSI.ORGANIZATION_ID = SHIP_FROM_ORG_ID;

Line: 211

    SELECT
      MEANING
    INTO V_VALUE
    FROM
      FND_LOOKUPS FND
    WHERE FND.LOOKUP_TYPE = 'RLM_DETAIL_SUBTYPE_CODE'
      AND DEMAND_BUCKET_TYPE_CODE = FND.LOOKUP_CODE;

Line: 227

    SELECT
      LOCATION
    INTO V_VALUE
    FROM
      HZ_CUST_SITE_USES
    WHERE SITE_USE_CODE = 'SHIP_TO'
      AND SITE_USE_ID = SHIP_TO_ORG_ID3;

Line: 244

      SELECT
        LOCATION
      INTO V_VALUE
      FROM
        HZ_CUST_SITE_USES
      WHERE SITE_USE_CODE = 'SHIP_TO'
        AND SITE_USE_ID = INTMED_SHIP_TO_ORG_ID;

Line: 262

      SELECT
        LOC.ADDRESS1
      INTO V_VALUE
      FROM
        HZ_CUST_SITE_USES_ALL CUST_SITE,
        HZ_PARTY_SITES PARTY_SITE,
        HZ_LOCATIONS LOC,
        HZ_CUST_ACCT_SITES ACCT_SITE
      WHERE CUST_SITE.SITE_USE_CODE = 'SHIP_TO'
        AND CUST_SITE.SITE_USE_ID = SHIP_TO_ORG_ID3
        AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
        AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
        AND ACCT_SITE.ORG_ID = CUST_SITE.ORG_ID
        AND ACCT_SITE.CUST_ACCT_SITE_ID = CUST_SITE.CUST_ACCT_SITE_ID;

Line: 287

      SELECT
        LOC.ADDRESS1
      INTO V_VALUE
      FROM
        HZ_CUST_SITE_USES_ALL CUST_SITE,
        HZ_PARTY_SITES PARTY_SITE,
        HZ_LOCATIONS LOC,
        HZ_CUST_ACCT_SITES ACCT_SITE
      WHERE CUST_SITE.SITE_USE_CODE = 'SHIP_TO'
        AND CUST_SITE.SITE_USE_ID = INTMED_SHIP_TO_ORG_ID
        AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
        AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
        AND ACCT_SITE.ORG_ID = CUST_SITE.ORG_ID
        AND ACCT_SITE.CUST_ACCT_SITE_ID = CUST_SITE.CUST_ACCT_SITE_ID;

Line: 311

    SELECT
      MEANING
    INTO V_VALUE
    FROM
      FND_LOOKUPS FND
    WHERE FND.LOOKUP_TYPE = 'RLM_DETAIL_SUBTYPE_CODE'
      AND DEMAND_BUCKET_TYPE_CODE1 = FND.LOOKUP_CODE;

Line: 327

    SELECT
      CUM_START_DATE
    INTO V_CUM_START
    FROM
      RLM_CUST_ITEM_CUM_KEYS CMKEYS
    WHERE VEH_CUS_ITEM_CUM_KEY_ID = CMKEYS.CUM_KEY_ID;

Line: 342

    SELECT
      CUM_QTY
    INTO V_CUM_QTY
    FROM
      RLM_CUST_ITEM_CUM_KEYS CMKEYS
    WHERE VEH_CUS_ITEM_CUM_KEY_ID = CMKEYS.CUM_KEY_ID;

Line: 354

  FUNCTION LAST_CUM_QTY_UPDATE_DATEFORMU(VEH_CUS_ITEM_CUM_KEY_ID IN NUMBER) RETURN DATE IS
    V_CUM_START DATE;

Line: 357

    SELECT
      LAST_CUM_QTY_UPDATE_DATE
    INTO V_CUM_START
    FROM
      RLM_CUST_ITEM_CUM_KEYS CMKEYS
    WHERE VEH_CUS_ITEM_CUM_KEY_ID = CMKEYS.CUM_KEY_ID;

Line: 367

  END LAST_CUM_QTY_UPDATE_DATEFORMU;

Line: 377

        SELECT
          MEANING
        INTO X_SCHEDULE_TYPE
        FROM
          FND_LOOKUPS
        WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_TYPE'
          AND LOOKUP_CODE = SCHEDULE_TYPE;

Line: 401

        SELECT
          MEANING
        INTO X_SCHEDULE_TYPE
        FROM
          FND_LOOKUPS
        WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_TYPE'
          AND LOOKUP_CODE = SCHEDULE_TYPE2;