APPS.RLM_RLMDMCOM_XMLP_PKG SQL Statements

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

Line: 7

      SELECT
        MEANING
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_TYPE'
        AND LOOKUP_CODE = V_SCHEDULE_TYPE
        AND ENABLED_FLAG = 'Y';

Line: 15

      SELECT
        SCHEDULE_REFERENCE_NUM
      FROM
        RLM_SCHEDULE_HEADERS_ALL
      WHERE HEADER_ID = V_SCH_REF_NUM;

Line: 21

      SELECT
        ORGANIZATION_CODE
      FROM
        ORG_ORGANIZATION_DEFINITIONS
      WHERE ORGANIZATION_ID = V_SHIP_FROM;

Line: 27

      SELECT
        ECE_TP_LOCATION_CODE
      FROM
        HZ_CUST_ACCT_SITES
      WHERE CUST_ACCT_SITE_ID = NU_SHIP_TO;

Line: 33

      SELECT
        MEANING
      FROM
        FND_COMMON_LOOKUPS
      WHERE LOOKUP_TYPE = 'RLM_FIRM_FORECAST_BOTH'
        AND LOOKUP_CODE = V_DEMAND_TYPE
        AND ENABLED_FLAG = 'Y';

Line: 41

      SELECT
        MEANING
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = V_DISCREP
        AND ENABLED_FLAG = 'Y';

Line: 49

      SELECT
        MEANING
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_TYPE = 'RLM_OPTIONAL_MATCH_ATTRIBUTES'
        AND ENABLED_FLAG = 'Y'
        AND LOOKUP_CODE = P_SEQ_MATCH;

Line: 146

      SELECT
        ORGANIZATION_NAME
      FROM
        ORG_ORGANIZATION_DEFINITIONS HRORGS
      WHERE HRORGS.ORGANIZATION_ID = NU_SHIP_FROM;

Line: 165

      SELECT
        ECE_TP_LOCATION_CODE
      FROM
        HZ_CUST_ACCT_SITES
      WHERE CUST_ACCT_SITE_ID = NU_SHIP_TO;

Line: 184

      SELECT
        MEANING
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_TYPE = 'RLM_FIRM_DISP_CODE'
        AND LOOKUP_CODE = V_PRE_HORIZ_DISP_CODE;

Line: 204

      SELECT
        MEANING
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_TYPE = 'RLM_INTRANSIT_CALC_BASIS'
        AND LOOKUP_CODE = V_INTRANSIT_CAL
        AND ENABLED_FLAG = 'Y';

Line: 237

      SELECT
        MEANING,
        SUBSTR(LOOKUP_CODE
              ,INSTR(LOOKUP_CODE
                   ,',') + 1)
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_TYPE = 'RLM_OPTIONAL_MATCH_ATTRIBUTES'
        AND ENABLED_FLAG = 'Y'
        AND LOOKUP_CODE = P_SEQ_MATCH;

Line: 309

      SELECT
        ORDER_NUMBER
      FROM
        OE_ORDER_HEADERS
      WHERE HEADER_ID = NU_ORDER_NUM;

Line: 332

      SELECT
        CUST_ACCT.ACCOUNT_NUMBER
      FROM
        HZ_PARTIES PARTY,
        HZ_CUST_ACCOUNTS CUST_ACCT
      WHERE PARTY.PARTY_ID = CUST_ACCT.PARTY_ID
        AND CUST_ACCT.CUST_ACCOUNT_ID = CUST_NUM;

Line: 353

      SELECT
        MEANING
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = V_FLAG_CODE
        AND ENABLED_FLAG = 'Y';

Line: 374

      SELECT
        MEANING
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_TYPE = 'RLM_TIME_UOM'
        AND LOOKUP_CODE = V_TIME_UOM
        AND ENABLED_FLAG = 'Y';

Line: 395

      SELECT
        MEANING
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = V_EXC_NONWORKDAYS_FLAG
        AND ENABLED_FLAG = 'Y';