APPS.MRP_MRPRPSST_XMLP_PKG SQL Statements

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

Line: 51

      SELECT
        MEANING
      INTO SCHED_VERSION
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'MRP_SCHEDULE_LEVEL'
        AND LOOKUP_CODE = P_SCHED_VERSION;

Line: 68

      SELECT
        MEANING
      INTO SORT
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'MRP_DATA_SELECT'
        AND LOOKUP_CODE = P_SORT;

Line: 85

      SELECT
        CATEGORY_SET_NAME
      INTO CAT_SET
      FROM
        MTL_CATEGORY_SETS
      WHERE CATEGORY_SET_ID = P_CAT_SET;

Line: 150

        SELECT
          STRUCTURE_ID
        INTO CAT_STRUCT_NUM
        FROM
          MTL_DEFAULT_SETS_VIEW
        WHERE FUNCTIONAL_AREA_ID = 3;

Line: 158

      SELECT
        DECODE(LOOKUP_CODE
              ,1
              ,12
              ,2
              ,24
              ,3
              ,36
              ,4
              ,48
              ,12),
        MRP_FORM_QUERY_S.NEXTVAL,
        P_START_DATE
      INTO PERIODS,QUERY_ID,START_DATE
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'MRP_DISPLAY_PERIODS'
        AND LOOKUP_CODE = P_PERIODS;

Line: 196

      SELECT
        CALENDAR_CODE,
        CALENDAR_EXCEPTION_SET_ID
      INTO CAL_CODE,CAL_EXCEPTION_SET_ID
      FROM
        MTL_PARAMETERS
      WHERE ORGANIZATION_ID = P_ORG_ID;

Line: 205

      SELECT
        NAME,
        PRECISION
      INTO CURRENCY_DESC,PRECISION
      FROM
        FND_CURRENCIES_VL
      WHERE CURRENCY_CODE = P_CURRENCY_CODE;

Line: 214

      SELECT
        MEANING
      INTO SCHEDULE_TYPE
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'MRP_SCHEDULE_TYPE'
        AND LOOKUP_CODE = P_SCHED_TYPE;

Line: 222

      SELECT
        MEANING
      INTO SCHEDULE_VERSION
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'MRP_SCHEDULE_LEVEL'
        AND LOOKUP_CODE = P_SCHED_VERSION;

Line: 237

      ORG_SELECTION NUMBER := 0;

Line: 241

        SELECT
          ORGANIZATION_SELECTION
        INTO ORG_SELECTION
        FROM
          MRP_SCHEDULE_DESIGNATORS SCHED
        WHERE ORGANIZATION_ID = P_ORG_ID
          AND SCHEDULE_DESIGNATOR = P_SCHED_NAME;

Line: 248

        IF (ORG_SELECTION = 2 OR ORG_SELECTION = 3) THEN
          USE_MULTIORG_MPS := 1;

Line: 282

        SELECT
          MEANING
        INTO REPORT_MULTIORG_TEXT
        FROM
          MFG_LOOKUPS
        WHERE LOOKUP_CODE = P_REPORT_MULTIORG
          AND LOOKUP_TYPE = 'MRP_REPORT_MULTIORG';

Line: 298

      ORG_SELECTION NUMBER;

Line: 302

        SELECT
          ORGANIZATION_SELECTION
        INTO ORG_SELECTION
        FROM
          MRP_SCHEDULE_DESIGNATORS SCHED
        WHERE ORGANIZATION_ID = P_ORG_ID
          AND SCHEDULE_DESIGNATOR = P_SCHED_NAME;

Line: 310

        SELECT
          DISTINCT
          NVL(SCHED.ORGANIZATION_SELECTION
             ,0)
        INTO ORG_SELECTION
        FROM
          MRP_SCHEDULE_DESIGNATORS SCHED,
          MRP_ORGANIZATIONS_V MO
        WHERE SCHED.ORGANIZATION_ID = mo.organization_id (+)
          AND SCHED.SCHEDULE_DESIGNATOR = mo.compile_designator (+)
          AND NVL(MO.PLANNED_ORGANIZATION
           ,SCHED.ORGANIZATION_ID) = P_ORG_ID
          AND SCHED.SCHEDULE_DESIGNATOR = P_SCHED_NAME;

Line: 324

      IF ((ORG_SELECTION = 2) OR (ORG_SELECTION = 3)) THEN
        USE_MULTIORG_PLAN := 1;