APPS.MRP_MRPRPPLO_XMLP_PKG SQL Statements

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

Line: 32

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

Line: 226

  FUNCTION C_P_ITEM_SELECTFORMULA RETURN VARCHAR2 IS
  BEGIN
    DECLARE
      ITEM_SELECT VARCHAR2(80);

Line: 231

      IF P_ITEM_SELECT IS NOT NULL THEN
        SELECT
          MEANING
        INTO ITEM_SELECT
        FROM
          MFG_LOOKUPS
        WHERE LOOKUP_CODE = P_ITEM_SELECT
          AND LOOKUP_TYPE = 'MTL_PLANNING_MAKE_BUY';

Line: 239

        RETURN (ITEM_SELECT);

Line: 245

  END C_P_ITEM_SELECTFORMULA;

Line: 252

      SELECT
        MEANING
      INTO INCLUDE_COST
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_CODE = P_INCLUDE_COST
        AND LOOKUP_TYPE = 'SYS_YES_NO';

Line: 269

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

Line: 287

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

Line: 305

      SELECT
        CATEGORY_SET_NAME
      INTO CAT_SET
      FROM
        MTL_CATEGORY_SETS
      WHERE CATEGORY_SET_ID = P_CAT_SET;

Line: 321

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

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

Line: 359

        SELECT
          DISTINCT
          ORGANIZATION_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: 394

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