APPS.BOM_CSTRITVR_XMLP_PKG SQL Statements

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

Line: 43

    SELECT
      O.ORGANIZATION_NAME,
      NVL(EXTENDED_PRECISION
         ,PRECISION),
      NVL(MINIMUM_ACCOUNTABLE_UNIT
         ,POWER(10
              ,NVL(-PRECISION
                 ,0))),
      MCS.CATEGORY_SET_NAME,
      DEFAULT_COST_TYPE_ID,
      COST_TYPE,
      LU1.MEANING,
      LU2.MEANING
    INTO P_ORGANIZATION,P_EXT_PREC,ROUND_UNIT,P_CAT_SET_NAME,P_DEF_COST_TYPE,P_COST_TYPE,P_SORT_BY,P_DETAIL_LEVEL
    FROM
      ORG_ORGANIZATION_DEFINITIONS O,
      FND_CURRENCIES FC,
      MTL_CATEGORY_SETS MCS,
      CST_COST_TYPES,
      MTL_PARAMETERS MP,
      MFG_LOOKUPS LU1,
      MFG_LOOKUPS LU2
    WHERE FC.CURRENCY_CODE = P_CURRENCY_CODE
      AND O.ORGANIZATION_ID = P_ORG_ID
      AND MCS.CATEGORY_SET_ID = P_CATEGORY_SET
      AND COST_TYPE_ID = NVL(P_COST_TYPE_ID
       ,MP.PRIMARY_COST_METHOD)
      AND MP.ORGANIZATION_ID = P_ORG_ID
      AND LU1.LOOKUP_TYPE (+) = 'CST_ITEM_REPORT_SORT'
      AND LU1.LOOKUP_CODE (+) = P_SORT_OPTION
      AND LU2.LOOKUP_TYPE (+) = 'CST_BICR_DETAIL_OPTION'
      AND LU2.LOOKUP_CODE (+) = P_RPT_OPTION;

Line: 76

    SELECT
      SOB.CURRENCY_CODE
    INTO L_FCN_CURRENCY
    FROM
      GL_SETS_OF_BOOKS SOB,
      ORG_ORGANIZATION_DEFINITIONS OOD
    WHERE OOD.ORGANIZATION_ID = P_ORG_ID
      AND SOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID;

Line: 145

    SELECT
      TO_CHAR(TO_DATE(P_AS_OF_DATE
                     ,'YYYY/MM/DD HH24:MI:SS')
             ,'DD-MON-YYYY HH24:MI:SS')
    INTO L_AS_OF_DATE
    FROM
      DUAL;