Product: | GL - General Ledger |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GL_ALLOC_FORMULAS_V |
SELECT AF.ROWID ROW_ID
, AF.ALLOCATION_FORMULA_ID ALLOCATION_FORMULA_ID
, AF.ALLOCATION_BATCH_ID ALLOCATION_BATCH_ID
, AF.NAME NAME
, AF.JE_CATEGORY_NAME JE_CATEGORY_NAME
, CAT.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, AF.DESCRIPTION DESCRIPTION
, AFL.TRANSACTION_CURRENCY TRANSACTION_CURRENCY
, AF.CONVERSION_METHOD_CODE CONVERSION_METHOD_CODE
, AF.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, DCT.USER_CONVERSION_TYPE USER_CONVERSION_TYPE
, AF.RUN_SEQUENCE RUN_SEQUENCE
, AF.FULL_ALLOCATION_FLAG FULL_ALLOCATION_FLAG
, AF.CREATION_DATE CREATION_DATE
, AF.CREATED_BY CREATED_BY
, AF.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AF.LAST_UPDATED_BY LAST_UPDATED_BY
, AF.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM GL_ALLOC_FORMULAS AF
, GL_ALLOC_FORMULA_LINES AFL
, GL_JE_CATEGORIES CAT
, GL_DAILY_CONVERSION_TYPES DCT
WHERE AFL.ALLOCATION_FORMULA_ID = AF.ALLOCATION_FORMULA_ID
AND AFL.LINE_NUMBER = 4
AND CAT.JE_CATEGORY_NAME = AF.JE_CATEGORY_NAME AND DCT.CONVERSION_TYPE(+) = AF.CURRENCY_CONVERSION_TYPE