View: GL_ALLOC_FORMULAS_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_ALLOC_FORMULAS_V

View Text

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
, L.MEANING SHOW_VALIDATION_STATUS
, AF.VALIDATION_STATUS VALIDATION_STATUS FROM GL_ALLOC_FORMULAS AF
, GL_ALLOC_FORMULA_LINES AFL
, GL_JE_CATEGORIES CAT
, GL_DAILY_CONVERSION_TYPES DCT
, GL_LOOKUPS L
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
AND L.LOOKUP_TYPE = 'VALIDATION_STATUS'
AND L.LOOKUP_CODE = AF.VALIDATION_STATUS

Columns