[Home] [Help]
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
Name |
CATEGORY_ID |
CATEGORY_CONCAT_SEGMENTS |
MNT_COST_ELEMENT_ID |
MNT_COST_ELEMENT |
MFG_COST_ELEMENT_ID |
MFG_COST_ELEMENT |
START_DATE |
END_DATE |
EXPENDITURE_TYPE |
EXPENDITURE_TYPE_ID |