APPS.WIP_WIPRDJVR_XMLP_PKG SQL Statements

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

Line: 79

      SELECT
        COUNT(*)
      INTO STD_ORG_COUNT
      FROM
        MTL_PARAMETERS
      WHERE ORGANIZATION_ID = ORG_ID
        AND PRIMARY_COST_METHOD = 1;

Line: 94

      select id_flex_num_cl
      into item_id_flex_num
      from(
      SELECT fifst.id_flex_num id_flex_num_cl
      FROM fnd_id_flex_structures fifst
      WHERE fifst.application_id = 401
      AND fifst.id_flex_code = 'MSTK'
      AND fifst.enabled_flag = 'Y'
      AND fifst.freeze_flex_definition_flag = 'Y'
      ORDER BY fifst.id_flex_num)
      where rownum<2;

Line: 106

      SELECT
        OOD.ORGANIZATION_NAME,
        SOB.CURRENCY_CODE,
        FC.EXTENDED_PRECISION,
        FC.PRECISION,
        RPT_SORT_OPT.MEANING,
        RPT_RUN_OPT.MEANING,
        ML1.MEANING,
        ML2.MEANING
      INTO ORG_NAME,CURRENCY_CODE,EXT_PRECISION,PRECISION,REPORT_SORT,REPORT_OPTION,C_INCLUDE_BULK,C_INCLUDE_VENDOR
      FROM
        FND_CURRENCIES FC,
        GL_SETS_OF_BOOKS SOB,
        ORG_ORGANIZATION_DEFINITIONS OOD,
        MFG_LOOKUPS RPT_SORT_OPT,
        MFG_LOOKUPS RPT_RUN_OPT,
        MFG_LOOKUPS ML1,
        MFG_LOOKUPS ML2
      WHERE OOD.ORGANIZATION_ID = ORG_ID
        AND OOD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
        AND SOB.CURRENCY_CODE = FC.CURRENCY_CODE
        AND FC.ENABLED_FLAG = 'Y'
        AND RPT_SORT_OPT.LOOKUP_TYPE = 'CST_WIP_REPORT_SORT'
        AND RPT_SORT_OPT.LOOKUP_CODE = REPORT_SORT_OPT
        AND RPT_RUN_OPT.LOOKUP_TYPE = 'CST_WIP_VALUE_REPORT_TYPE'
        AND RPT_RUN_OPT.LOOKUP_CODE = REPORT_RUN_OPT
        AND ML1.LOOKUP_CODE = NVL(P_INCLUDE_BULK
         ,2)
        AND ML1.LOOKUP_TYPE = 'SYS_YES_NO'
        AND ML2.LOOKUP_CODE = NVL(P_INCLUDE_VENDOR
         ,2)
        AND ML2.LOOKUP_TYPE = 'SYS_YES_NO';

Line: 141

        SELECT
          CLS_TYPE.MEANING
        INTO CLASS_TYPE_NAME
        FROM
          MFG_LOOKUPS CLS_TYPE
        WHERE CLS_TYPE.LOOKUP_TYPE = 'WIP_CLASS_TYPE'
          AND CLS_TYPE.LOOKUP_CODE = CLASS_TYPE;

Line: 152

        SELECT
          STS_TYPE.MEANING
        INTO STATUS_TYPE_NAME
        FROM
          MFG_LOOKUPS STS_TYPE
        WHERE STS_TYPE.LOOKUP_TYPE = 'WIP_JOB_STATUS'
          AND STS_TYPE.LOOKUP_CODE = STATUS_TYPE;

Line: 204

                            MODE="SELECT"  DISPLAY="ALL"
                            TABLEALIAS="MSI"')*/NULL;

Line: 239

                                         (select wip_entity_id
                                          from wip_dj_close_temp
                                          where group_id = :GROUP_ID)';