View: CSTFV_ITM_CST_GRP_UNT_CST_DTL

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CSTFV_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_QUANTITY_LAYERS CQL
, CST_LAYER_COST_DETAILS LCD
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