[Home] [Help]
View: CSTBV_LE_COST_TYPES
View Text
SELECT CLCT.LEGAL_ENTITY
, CLCT.COST_TYPE_ID
, XFI.NAME
, CCT.COST_TYPE
, CLCT.SET_OF_BOOKS_ID
, CLCT.PRIMARY_COST_METHOD
, CLCT.PAC_RATES_COST_TYPE_ID
, CLCT.CREATION_DATE
, CLCT.CREATED_BY
, CLCT.LAST_UPDATE_DATE
, CLCT.LAST_UPDATED_BY
FROM XLE_FIRSTPARTY_INFORMATION_V XFI
, CST_COST_TYPES CCT
, CST_LE_COST_TYPES CLCT
WHERE XFI.LEGAL_ENTITY_ID = CLCT.LEGAL_ENTITY
AND CCT.COST_TYPE_ID = CLCT.COST_TYPE_ID WITH READ ONLY
Columns
Name |
LEGAL_ENTITY |
COST_TYPE_ID |
LEGAL_ENTITY_NAME |
COST_TYPE_NAME |
LEDGER_ID |
PRIMARY_COST_METHOD_ID |
PAC_RATES_COST_TYPE_ID |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
UPDATED_BY |