APPS.MRP_MRPRPRSC_XMLP_PKG SQL Statements

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

Line: 20

      SELECT
        MEANING
      INTO CANCEL_TEXT
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'MRP_CANCEL'
        AND LOOKUP_CODE = 1;

Line: 30

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

Line: 40

        SELECT
          STRUCTURE_ID
        INTO CAT_STRUCT_NUM
        FROM
          MTL_DEFAULT_SETS_VIEW
        WHERE FUNCTIONAL_AREA_ID = 3;

Line: 317

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

Line: 334

      SELECT
        MEANING
      INTO ORDER_TYPE
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_CODE = P_ORDER_TYPE
        AND LOOKUP_TYPE = 'MRP_RESCHEDULE_SELECT';

Line: 352

        SELECT
          FULL_NAME
        INTO BUYER
        FROM
          MTL_EMPLOYEES_VIEW
        WHERE EMPLOYEE_ID = P_BUYER
          AND ORGANIZATION_ID = P_ORG_ID;

Line: 370

      SELECT
        CATEGORY_SET_NAME
      INTO CAT_SET
      FROM
        MTL_CATEGORY_SETS
      WHERE CATEGORY_SET_ID = P_CAT_SET;

Line: 386

      SELECT
        ASSIGNMENT_GROUP_NAME
      INTO ABC_ASSGN
      FROM
        MTL_ABC_ASSIGNMENT_GROUPS
      WHERE ASSIGNMENT_GROUP_ID = P_ABC_ASSGN
        AND ORGANIZATION_ID = P_ORG_ID;

Line: 406

      SELECT
        MEANING
      INTO CUTOFF_TYPE
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_CODE = P_CUTOFF_TYPE
        AND LOOKUP_TYPE = 'MRP_PL_ORDER_CUTOFF_TYPE';

Line: 501

        SELECT
          ABC_CLASS_NAME
        INTO ABC_CLASS
        FROM
          MTL_ABC_CLASSES
        WHERE ABC_CLASS_ID = P_ABC_CLASS
          AND ORGANIZATION_ID = P_ORG_ID;

Line: 517

      ORG_SELECTION NUMBER;

Line: 521

        SELECT
          ORGANIZATION_SELECTION
        INTO ORG_SELECTION
        FROM
          MRP_PLANS
        WHERE ORGANIZATION_ID = P_ORG_ID
          AND COMPILE_DESIGNATOR = P_PLAN_NAME;

Line: 529

        SELECT
          ORGANIZATION_SELECTION
        INTO ORG_SELECTION
        FROM
          MRP_PLAN_ORGANIZATIONS_V
        WHERE PLANNED_ORGANIZATION = P_ORG_ID
          AND COMPILE_DESIGNATOR = P_PLAN_NAME;

Line: 537

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

Line: 553

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