APPS.INV_INVISMMX_XMLP_PKG SQL Statements

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

Line: 25

          SELECT
            MEANING
          INTO ERROR_MESSAGE
          FROM
            MFG_LOOKUPS
          WHERE LOOKUP_TYPE = 'INV_MMX_RPT_MSGS'
            AND LOOKUP_CODE = 3;

Line: 48

    SELECT
      EMPLOYEE_ID
    INTO P_EMPLOYEE_ID
    FROM
      FND_USER
    WHERE USER_ID = P_USER_ID;

Line: 55

    SELECT
      sysdate
    INTO P_SYSDATE
    FROM
      SYS.DUAL;

Line: 82

      SELECT
        SUBSTR(NAME
              ,1
              ,30)
      INTO P_ORG_NAME
      FROM
        HR_ALL_ORGANIZATION_UNITS_TL
      WHERE ORGANIZATION_ID = P_ORG_ID
        AND LANGUAGE = USERENV('LANG');

Line: 95

      SELECT
        STRUCTURE_ID
      INTO P_MCAT_STRUCT
      FROM
        MTL_CATEGORY_SETS
      WHERE CATEGORY_SET_ID = P_CAT_SET_ID;

Line: 102

      SELECT
        CSET.CATEGORY_SET_ID,
        CSET.STRUCTURE_ID
      INTO P_CAT_SET_ID,P_MCAT_STRUCT
      FROM
        MTL_CATEGORY_SETS CSET,
        MTL_DEFAULT_CATEGORY_SETS DEF
      WHERE DEF.CATEGORY_SET_ID = CSET.CATEGORY_SET_ID
        AND DEF.FUNCTIONAL_AREA_ID = 1;

Line: 113

    SELECT
      ID_FLEX_NUM
    INTO P_MSTK_STRUCT
    FROM
      FND_ID_FLEX_STRUCTURES
    WHERE ID_FLEX_CODE = 'MSTK';

Line: 119

    SELECT
      MEANING
    INTO P_SORTER
    FROM
      MFG_LOOKUPS
    WHERE LOOKUP_TYPE = 'MTL_MINMAX_RPT_SORT_BY'
      AND LOOKUP_CODE = DECODE(P_SORT
          ,1
          ,2
          ,P_SORT);

Line: 182

    SELECT
      MEANING
    INTO P_SB_TEXT
    FROM
      MFG_LOOKUPS
    WHERE LOOKUP_TYPE = 'MTL_MINMAX_RPT_SORT_BY'
      AND LOOKUP_CODE = P_SORT;

Line: 189

    SELECT
      MEANING
    INTO P_SELECTION_TEXT
    FROM
      MFG_LOOKUPS
    WHERE LOOKUP_TYPE = 'MTL_MINMAX_RPT_SEL'
      AND LOOKUP_CODE = P_SELECTION;

Line: 196

    SELECT
      MEANING
    INTO P_LVL_TEXT
    FROM
      MFG_LOOKUPS
    WHERE LOOKUP_TYPE = 'MTL_MINMAX_LEVEL'
      AND LOOKUP_CODE = P_LEVEL;

Line: 203

    SELECT
      MEANING
    INTO P_DISPLAY_MODE_TEXT
    FROM
      MFG_LOOKUPS
    WHERE LOOKUP_TYPE = 'INV_SRS_MMX_REPORT_FORMAT'
      AND LOOKUP_CODE = P_DISPLAY_MODE;

Line: 214

    SELECT
      MEANING
    INTO P_REPITM_TEXT
    FROM
      MFG_LOOKUPS
    WHERE LOOKUP_TYPE = 'MTL_MINMAX_HANDLE_REP_ITEM'
      AND LOOKUP_CODE = P_HANDLE_REP_ITEM;

Line: 222

      SELECT
        LOCATION_CODE
      INTO P_DDL_TEXT
      FROM
        HR_LOCATIONS LOC
      WHERE LOC.LOCATION_ID = P_DD_LOC_ID;

Line: 230

    SELECT
      CATEGORY_SET_NAME
    INTO P_CSET_TEXT
    FROM
      MTL_CATEGORY_SETS
    WHERE CATEGORY_SET_ID = P_CAT_SET_ID;

Line: 236

    SELECT
      MEANING
    INTO P_YES_TEXT
    FROM
      MFG_LOOKUPS
    WHERE LOOKUP_TYPE = 'SYS_YES_NO'
      AND LOOKUP_CODE = 1;

Line: 243

    SELECT
      MEANING
    INTO P_NO_TEXT
    FROM
      MFG_LOOKUPS
    WHERE LOOKUP_TYPE = 'SYS_YES_NO'
      AND LOOKUP_CODE = 2;

Line: 251

    SELECT
      MEANING
    INTO P_LOTCTL_TEXT
    FROM
      MFG_LOOKUPS
    WHERE LOOKUP_TYPE = 'MIN_MAX_REPORT_LOT_CONTROL'
      AND LOOKUP_CODE = NVL(P_LOT_CTL
       ,3);

Line: 328

                                    ,P_ITEM_SELECT => P_ITEM_SELECT
                                    ,P_HANDLE_REP_ITEM => P_HANDLE_REP_ITEM
                                    ,P_PUR_REVISION => P_PUR_REVISION
                                    ,P_CAT_SELECT => P_CAT_SELECT
                                    ,P_CAT_SET_ID => P_CAT_SET_ID
                                    ,P_MCAT_STRUCT => P_MCAT_STRUCT
                                    ,P_LEVEL => P_LEVEL
                                    ,P_RESTOCK => P_RESTOCK
                                    ,P_INCLUDE_NONNET => P_INCLUDE_NONNET
                                    ,P_INCLUDE_PO => P_INCLUDE_PO
                                    ,P_INCLUDE_MO => P_INCLUDE_MO
                                    ,P_INCLUDE_WIP => P_INCLUDE_WIP
                                    ,P_INCLUDE_IF => P_INCLUDE_IF
                                    ,P_NET_RSV => P_NET_RSV
                                    ,P_NET_UNRSV => P_NET_UNRSV
                                    ,P_NET_WIP => P_NET_WIP
                                    ,P_ORGANIZATION_ID => P_ORG_ID
                                    ,P_USER_ID => P_USER_ID
                                    ,P_EMPLOYEE_ID => P_EMPLOYEE_ID
                                    ,P_SUBINV_TBL => L_SUBINV_TBL
                                    ,P_DD_LOC_ID => P_DD_LOC_ID
                                    ,P_BUYER_HI => P_BUYER_HI
                                    ,P_BUYER_LO => P_BUYER_LO
                                    ,P_RANGE_BUYER => P_RANGE_BUYER
                                    ,P_RANGE_SQL => P_RANGE_SQL
                                    ,P_SORT => P_SORT
                                    ,P_SELECTION => P_SELECTION
                                    ,P_SYSDATE => P_SYSDATE
                                    ,P_S_CUTOFF => P_S_CUTOFF_1
                                    ,P_D_CUTOFF => P_D_CUTOFF_1
                                    ,P_GEN_REPORT => 'Y'
                                    ,P_MO_LINE_GROUPING => P_MO_LINE_GROUPING);

Line: 373

          FND_MSG_PUB.DELETE_MSG(I);

Line: 405

      DELETE FROM INV_MIN_MAX_TEMP;