VIEW: APPS.GL_ALLOC_FORMULAS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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