Product: | BOM - Bills of Material |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CSTFV_LE_COST_TYPES |
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