VIEW: APPS.CST_LE_COST_TYPES_V

Source

View Text - Preformatted

SELECT clct.LEGAL_ENTITY, clct.COST_TYPE_ID, clct.SET_OF_BOOKS_ID, clct.PRIMARY_COST_METHOD, clct.PAC_RATES_COST_TYPE_ID , clct.LAST_UPDATE_DATE, clct.LAST_UPDATED_BY, clct.CREATION_DATE, clct.CREATED_BY, clct.REQUEST_ID, clct.PROGRAM_APPLICATION_ID, clct.PROGRAM_ID, clct.PROGRAM_UPDATE_DATE, clct.LAST_UPDATE_LOGIN, clct.CREATE_ACCT_ENTRIES, clct.ACCOUNTING_LIBRARY_ID, clct.POST_TO_GL, clct.GL_TRANSFER_ALLOW_OVERRIDE, clct.GL_TRANSFER_MODE, clct.GL_TRANSFER_SUBMIT_JOURNAL_IMP, xfi.name LEGAL_ENTITY_NAME, cct.COST_TYPE, cct.description COST_TYPE_DESC, gsob.short_name SET_OF_BOOKS_NAME, ml.meaning PRIMARY_COST_METHOD_NAME, cct1.cost_type PAC_RATES_COST_TYPE, cct1.description PAC_RATES_COST_TYPE_DESC, cal.lib_name ACCOUNTING_LIBRARY_NAME FROM cst_le_cost_types clct, xle_firstparty_information_v xfi, cst_cost_types cct, cst_cost_types cct1, gl_sets_of_books gsob, mfg_lookups ml, cst_accounting_libraries cal WHERE cct.cost_type_id = clct.cost_type_id AND cct1.cost_type_id = clct.pac_rates_cost_type_id AND xfi.legal_entity_id = clct.legal_entity AND gsob.set_of_books_id = clct.set_of_books_id AND ml.lookup_type = 'MTL_PRIMARY_COST' AND ml.lookup_code = clct.primary_cost_method AND cal.accounting_lib_id(+) = clct.accounting_library_id

View Text - HTML Formatted

SELECT CLCT.LEGAL_ENTITY
, CLCT.COST_TYPE_ID
, CLCT.SET_OF_BOOKS_ID
, CLCT.PRIMARY_COST_METHOD
, CLCT.PAC_RATES_COST_TYPE_ID
, CLCT.LAST_UPDATE_DATE
, CLCT.LAST_UPDATED_BY
, CLCT.CREATION_DATE
, CLCT.CREATED_BY
, CLCT.REQUEST_ID
, CLCT.PROGRAM_APPLICATION_ID
, CLCT.PROGRAM_ID
, CLCT.PROGRAM_UPDATE_DATE
, CLCT.LAST_UPDATE_LOGIN
, CLCT.CREATE_ACCT_ENTRIES
, CLCT.ACCOUNTING_LIBRARY_ID
, CLCT.POST_TO_GL
, CLCT.GL_TRANSFER_ALLOW_OVERRIDE
, CLCT.GL_TRANSFER_MODE
, CLCT.GL_TRANSFER_SUBMIT_JOURNAL_IMP
, XFI.NAME LEGAL_ENTITY_NAME
, CCT.COST_TYPE
, CCT.DESCRIPTION COST_TYPE_DESC
, GSOB.SHORT_NAME SET_OF_BOOKS_NAME
, ML.MEANING PRIMARY_COST_METHOD_NAME
, CCT1.COST_TYPE PAC_RATES_COST_TYPE
, CCT1.DESCRIPTION PAC_RATES_COST_TYPE_DESC
, CAL.LIB_NAME ACCOUNTING_LIBRARY_NAME
FROM CST_LE_COST_TYPES CLCT
, XLE_FIRSTPARTY_INFORMATION_V XFI
, CST_COST_TYPES CCT
, CST_COST_TYPES CCT1
, GL_SETS_OF_BOOKS GSOB
, MFG_LOOKUPS ML
, CST_ACCOUNTING_LIBRARIES CAL
WHERE CCT.COST_TYPE_ID = CLCT.COST_TYPE_ID
AND CCT1.COST_TYPE_ID = CLCT.PAC_RATES_COST_TYPE_ID
AND XFI.LEGAL_ENTITY_ID = CLCT.LEGAL_ENTITY
AND GSOB.SET_OF_BOOKS_ID = CLCT.SET_OF_BOOKS_ID
AND ML.LOOKUP_TYPE = 'MTL_PRIMARY_COST'
AND ML.LOOKUP_CODE = CLCT.PRIMARY_COST_METHOD
AND CAL.ACCOUNTING_LIB_ID(+) = CLCT.ACCOUNTING_LIBRARY_ID