APPS.MRP_MRPRPLOR_XMLP_PKG SQL Statements

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

Line: 170

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

Line: 195

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

Line: 212

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

Line: 229

      SELECT
        CATEGORY_SET_NAME
      INTO CAT_SET
      FROM
        MTL_CATEGORY_SETS
      WHERE CATEGORY_SET_ID = P_CAT_SET;

Line: 244

      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: 264

        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: 279

      ORG_SELECTION NUMBER;

Line: 282

      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: 293

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

Line: 308

        SELECT
          MEANING
        INTO ORG_TYPE
        FROM
          MFG_LOOKUPS
        WHERE LOOKUP_CODE = P_ORG_TYPE
          AND LOOKUP_TYPE = 'MRP_REPORT_MULTIORG';