VIEW: APPS.CSTBV_ITM_CST_GRP_UNT_CST_DTL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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