View: CST_LE_COST_TYPES_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_LE_COST_TYPES_V

View Text

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

Columns