[Home] [Help]
View: CSTBV_COST_ELEMENTS
View Text
SELECT /* UNIQUE ATTRIBUTES */ CCE.COST_ELEMENT_ID
, /* REGULAR ATTRIBUTES */ CCE.COST_ELEMENT
, CCE.DESCRIPTION
, CCEET.EXPENDITURE_TYPE_IN
, CCEET.EXPENDITURE_TYPE_OUT
, /* RESOLVE FOREIGN KEY RESOLUTIONS */ /* ID */ /* WHO */ CCE.CREATION_DATE
, CCE.CREATED_BY
, CCE.LAST_UPDATE_DATE
, CCE.LAST_UPDATED_BY
FROM CST_COST_ELEM_EXP_TYPES CCEET
, CST_COST_ELEMENTS CCE
WHERE CCE.COST_ELEMENT_ID = CCEET.COST_ELEMENT_ID WITH READ ONLY
Columns
Name |
COST_ELEMENT_ID |
COST_ELEMENT_NAME |
DESCRIPTION |
EXPENDITURE_TRANSFER_IN_TYPE |
EXPENDITURE_TRANSFER_OUT_TYPE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |