APPS.MRP_MRPRPPIT_XMLP_PKG SQL Statements

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

Line: 8

      SELECT
        ORGANIZATION_CODE
      INTO ORG_CODE
      FROM
        MTL_PARAMETERS
      WHERE ORGANIZATION_ID = C_PLANNED_ORGANIZATION;

Line: 24

      SELECT
        DESCRIPTION
      INTO COST_TYPE
      FROM
        CST_COST_TYPES
      WHERE COST_TYPE_ID = P_COST_TYPE;

Line: 54

        SELECT
          ORG_V.COMPILE_DESIGNATOR,
          PLN_SCHED.INPUT_DESIGNATOR_NAME,
          ORG_V.PLANNED_ORGANIZATION
        FROM
          MRP_PLAN_ORGANIZATIONS_V ORG_V,
          MRP_PLAN_SCHEDULES_V PLN_SCHED
        WHERE PLN_SCHED.INPUT_ORGANIZATION_ID = ORG_V.PLANNED_ORGANIZATION
          AND PLN_SCHED.COMPILE_DESIGNATOR = ORG_V.COMPILE_DESIGNATOR
          AND DECODE(P_ORG_TYPE
              ,1
              ,ORG_V.PLANNED_ORGANIZATION
              ,ORG_V.ORGANIZATION_ID) = P_ORG_ID
          AND ORG_V.COMPILE_DESIGNATOR = P_PLAN_NAME;

Line: 75

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

Line: 92

      SELECT
        MRP_FORM_QUERY_S.NEXTVAL
      INTO Q_ID
      FROM
        DUAL;

Line: 105

      SELECT
        DISTINCT
        PLAN.EXPLOSION_COMPLETION_DATE,
        PLAN.DATA_COMPLETION_DATE,
        PLAN.PLAN_COMPLETION_DATE,
        PLAN.PLAN_COMPLETION_DATE
      INTO EXPLOSION_DATE,SNAPSHOT_DATE,PLAN_DATE,START_DATE
      FROM
        MRP_PLAN_ORGANIZATIONS_V ORG_V,
        MRP_PLANS PLAN
      WHERE DECODE(P_ORG_TYPE
            ,1
            ,ORG_V.PLANNED_ORGANIZATION
            ,ORG_V.ORGANIZATION_ID) = P_ORG_ID
        AND ORG_V.COMPILE_DESIGNATOR = P_PLAN_NAME
        AND ORG_V.ORGANIZATION_ID = PLAN.ORGANIZATION_ID
        AND ORG_V.COMPILE_DESIGNATOR = PLAN.COMPILE_DESIGNATOR;

Line: 129

      SELECT
        DEFAULT_COST_TYPE_ID
      INTO DEF_COST_TYPE_ID
      FROM
        CST_COST_TYPES
      WHERE COST_TYPE_ID = P_COST_TYPE;

Line: 140

        SELECT
          MRP_FORM_QUERY_S.NEXTVAL
        INTO Q_ID
        FROM
          DUAL;

Line: 158

          'UPDATE mrp_form_query SET query_id = ' || TO_CHAR(P_QUERY_ID) || ' WHERE query_id = ' || TO_CHAR(Q_ID);

Line: 161

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

Line: 202

      ORG_SELECTION NUMBER := 1;

Line: 205

      SELECT
        DISTINCT
        ORGANIZATION_SELECTION
      INTO ORG_SELECTION
      FROM
        MRP_PLAN_ORGANIZATIONS_V
      WHERE DECODE(P_ORG_TYPE
            ,1
            ,PLANNED_ORGANIZATION
            ,ORGANIZATION_ID) = P_ORG_ID
        AND COMPILE_DESIGNATOR = P_PLAN_NAME;

Line: 216

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

Line: 232

              DELETE FROM mrp_form_query WHERE query_id = ' || TO_CHAR(P_QUERY_ID);