View: CST_CAT_ELE_EXP_ASSOCS_V

Product:	BOM - Bills of Material
Description:	View table used for "Category Associations" form.
Implementation/DBA Data:	APPS.CST_CAT_ELE_EXP_ASSOCS_V

View Text

SELECT CCEEA.CATEGORY_ID
, MCK.CONCATENATED_SEGMENTS
, CCEEA.MNT_COST_ELEMENT_ID
, CECE.EAM_COST_ELEMENT
, CCEEA.MFG_COST_ELEMENT_ID
, CCE.COST_ELEMENT
, CCEEA.START_DATE
, CCEEA.END_DATE
, PET.EXPENDITURE_TYPE
, CCEEA.EXPENDITURE_TYPE_ID FROM CST_CAT_ELE_EXP_ASSOCS CCEEA
, MTL_CATEGORIES_B_KFV MCK
, CST_COST_ELEMENTS CCE
, CST_EAM_COST_ELEMENTS CECE
, PA_EXPENDITURE_TYPES PET
WHERE CCEEA.CATEGORY_ID = MCK.CATEGORY_ID
AND CCEEA.MNT_COST_ELEMENT_ID = CECE.EAM_COST_ELEMENT_ID
AND CCEEA.MFG_COST_ELEMENT_ID = CCE.COST_ELEMENT_ID
AND CCEEA.EXPENDITURE_TYPE_ID = PET.EXPENDITURE_TYPE_ID(+)

Columns