DBA Data[Home] [Help]

APPS.BOM_CSTRSTSR_XMLP_PKG SQL Statements

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

Line: 17

    SELECT
      OOD.ORGANIZATION_NAME,
      SOB.CURRENCY_CODE,
      NVL(FC.MINIMUM_ACCOUNTABLE_UNIT
         ,POWER(10
              ,NVL(-FC.PRECISION
                 ,0))),
      MCS.CATEGORY_SET_NAME,
      LOOKUP1.MEANING
    INTO PV_ORGANIZATION_NAME,L_FCN_CURRENCY,PV_ROUND_UNIT,PV_CATEGORY_SET_NAME,PV_SORT_OPTION
    FROM
      ORG_ORGANIZATION_DEFINITIONS OOD,
      GL_SETS_OF_BOOKS SOB,
      FND_CURRENCIES FC,
      MTL_CATEGORY_SETS MCS,
      MFG_LOOKUPS LOOKUP1
    WHERE OOD.ORGANIZATION_ID = P_ORG_ID
      AND SOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
      AND FC.CURRENCY_CODE = P_CURRENCY_CODE
      AND MCS.CATEGORY_SET_ID = P_CATEGORY_SET
      AND LOOKUP1.LOOKUP_TYPE = 'CST_ITEM_REPORT_SORT'
      AND LOOKUP1.LOOKUP_CODE = P_SORT_OPTION;