APPS.BOM_CSTRDJVA_XMLP_PKG SQL Statements

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

Line: 71

    SELECT fifst.id_flex_num
into p_item_flex_num
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'
and rownum<2;

Line: 82

      SELECT
        COUNT(*)
      INTO AVG_ORG_COUNT
      FROM
        MTL_PARAMETERS
      WHERE ORGANIZATION_ID = ORG_ID
        AND PRIMARY_COST_METHOD IN ( 2 , 5 , 6 );

Line: 96

      IF P_JOB_SELECTION = 1 THEN
        SELECT
          COST_GROUP
        INTO SELECTED_COST_GROUP
        FROM
          CST_COST_GROUPS
        WHERE COST_GROUP_ID = P_COST_GROUP_ID;

Line: 105

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

        SELECT
          OOD.ORGANIZATION_NAME,
          FC.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 FC.CURRENCY_CODE = LP_CURRENCY_CODE
          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: 184

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

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

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

Line: 276

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

Line: 389

  FUNCTION SELECTED_COST_GROUP_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECTED_COST_GROUP;

Line: 392

  END SELECTED_COST_GROUP_P;