VIEW: APPS.CSTFV_LE_COST_TYPES

Source

View Text - Preformatted

SELECT clct.LEGAL_ENTITY, clct.COST_TYPE_ID, xfi.name, cct.cost_type, gsob.name, '_LA:clct.PRIMARY_COST_METHOD:MFG_LOOKUPS:MTL_PRIMARY_COST:MEANING', cct1.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 gl_sets_of_books gsob, xle_firstparty_information_v XFI, cst_cost_types cct, cst_cost_types cct1, CST_LE_COST_TYPES clct WHERE xfi.legal_entity_id = clct.LEGAL_ENTITY and gsob.SET_OF_BOOKS_ID = clct.SET_OF_BOOKS_ID and cct.COST_TYPE_ID = clct.COST_TYPE_ID and cct1.COST_TYPE_ID = clct.PAC_RATES_COST_TYPE_ID with read only

View Text - HTML Formatted

SELECT CLCT.LEGAL_ENTITY
, CLCT.COST_TYPE_ID
, XFI.NAME
, CCT.COST_TYPE
, GSOB.NAME
, '_LA:CLCT.PRIMARY_COST_METHOD:MFG_LOOKUPS:MTL_PRIMARY_COST:MEANING'
, CCT1.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 GL_SETS_OF_BOOKS GSOB
, XLE_FIRSTPARTY_INFORMATION_V XFI
, CST_COST_TYPES CCT
, CST_COST_TYPES CCT1
, CST_LE_COST_TYPES CLCT
WHERE XFI.LEGAL_ENTITY_ID = CLCT.LEGAL_ENTITY
AND GSOB.SET_OF_BOOKS_ID = CLCT.SET_OF_BOOKS_ID
AND CCT.COST_TYPE_ID = CLCT.COST_TYPE_ID
AND CCT1.COST_TYPE_ID = CLCT.PAC_RATES_COST_TYPE_ID WITH READ ONLY