APPS.RLM_RLMDPDER_XMLP_PKG SQL Statements

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

Line: 103

        SELECT
          NAME
        INTO P_ORDER_TYPE_NAME_FROM
        FROM
          OE_ORDER_TYPES_V
        WHERE ORDER_TYPE_ID = P_ORDER_TYPE_FROM;

Line: 113

        SELECT
          NAME
        INTO P_ORDER_TYPE_NAME_TO
        FROM
          OE_ORDER_TYPES_V
        WHERE ORDER_TYPE_ID = P_ORDER_TYPE_TO;

Line: 191

        SELECT
          MEANING
        FROM
          FND_LOOKUPS
        WHERE LOOKUP_TYPE = 'RLM_DETAIL_TYPE_CODE'
          AND LOOKUP_CODE = ITEM_DETAIL_TYPE;

Line: 218

        SELECT
          MEANING
        FROM
          FND_LOOKUPS
        WHERE LOOKUP_TYPE = 'RLM_DETAIL_SUBTYPE_CODE'
          AND LOOKUP_CODE = ITEM_DETAIL_SUBTYPE;

Line: 245

        SELECT
          NAME
        FROM
          OE_ORDER_TYPES_V
        WHERE ORDER_TYPE_ID = ORDER_TYPE_ID;

Line: 284

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

Line: 304

      SELECT
        MEANING
      INTO X_SCHEDULE_PURPOSE
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_PURPOSE'
        AND LOOKUP_CODE = SCHEDULE_PURPOSE;

Line: 325

        SELECT
          MEANING
        INTO X_SCHEDULE_SOURCE
        FROM
          FND_LOOKUPS
        WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_SOURCE'
          AND LOOKUP_CODE = SCHEDULE_SOURCE;