[Home] [Help]
View: CSTBV_ITM_CST_GRP_UNT_CST_DTL
View Text
SELECT /* UNIQUE ATTRIBUTES */ '_LA:LCD.LEVEL_TYPE:MFG_LOOKUPS:CST_LEVEL:MEANING' /* REGULAR ATTRIBUTES */
, LCD.ITEM_COST /* FOREIGN KEYS RESOLVED */
, MP.ORGANIZATION_CODE
, HR.NAME
, '_KF:INV:MSTK:SY'
, CG.COST_GROUP
, CE.COST_ELEMENT /* IDS */
, LCD.LEVEL_TYPE
, LCD.COST_ELEMENT_ID
, LCD.LAYER_ID /* WHO */
, LCD.CREATION_DATE
, LCD.CREATED_BY
, LCD.LAST_UPDATE_DATE
, LCD.LAST_UPDATED_BY
FROM MTL_PARAMETERS MP
, MTL_SYSTEM_ITEMS SY
, CST_COST_GROUPS CG
, CST_COST_ELEMENTS CE
, HR_ALL_ORGANIZATION_UNITS HR
, CST_LAYER_COST_DETAILS LCD
, CST_QUANTITY_LAYERS CQL
WHERE LCD.LAYER_ID = CQL.LAYER_ID
AND CQL.ORGANIZATION_ID = HR.ORGANIZATION_ID
AND CQL.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND CQL.COST_GROUP_ID = CG.COST_GROUP_ID
AND SY.ORGANIZATION_ID = CQL.ORGANIZATION_ID
AND SY.INVENTORY_ITEM_ID = CQL.INVENTORY_ITEM_ID
AND LCD.COST_ELEMENT_ID = CE.COST_ELEMENT_ID
AND '_SEC:CQL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
Columns
Name |
"_LA:LEVEL" |
ITEM_COST |
ORGANIZATION_CODE |
ORGANIZATION_NAME |
"_KF:ITEM_NUMBER:_CO" |
COST_GROUP |
COST_ELEMENT_NAME |
LEVEL_TYPE |
COST_ELEMENT_ID |
LAYER_ID |
CREATED_DATE |
CREATED_BY |
UPDATED_DATE |
UPDATED_BY |