VIEW: APPS.CSTBV_AVERAGE_ITEM_COSTS

Source

View Text - Preformatted

SELECT /* UNIQUE ATTRIBUTES */ CQL.LAYER_ID , CQL.ORGANIZATION_ID , CQL.INVENTORY_ITEM_ID /* REGULAR ATTRIBUTES */ , CQL.ITEM_COST , CQL.MATERIAL_COST , CQL.MATERIAL_OVERHEAD_COST , CQL.OVERHEAD_COST , CQL.RESOURCE_COST , CQL.OUTSIDE_PROCESSING_COST /* FOREIGN KEYS RESOLVED */ , MP.ORGANIZATION_CODE , HR.NAME , '_KF:INV:MSTK:sy' /* IDS */ , CQL.COST_GROUP_ID /* WHO */ , CQL.CREATION_DATE , CQL.CREATED_BY , CQL.LAST_UPDATE_DATE , CQL.LAST_UPDATED_BY FROM MTL_SYSTEM_ITEMS SY ,HR_ALL_ORGANIZATION_UNITS HR ,MTL_PARAMETERS MP ,CST_QUANTITY_LAYERS CQL WHERE CQL.ORGANIZATION_ID = HR.ORGANIZATION_ID AND CQL.ORGANIZATION_ID = MP.ORGANIZATION_ID AND SY.ORGANIZATION_ID = CQL.ORGANIZATION_ID AND SY.INVENTORY_ITEM_ID = CQL.INVENTORY_ITEM_ID AND '_SEC:cql.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ CQL.LAYER_ID
, CQL.ORGANIZATION_ID
, CQL.INVENTORY_ITEM_ID /* REGULAR ATTRIBUTES */
, CQL.ITEM_COST
, CQL.MATERIAL_COST
, CQL.MATERIAL_OVERHEAD_COST
, CQL.OVERHEAD_COST
, CQL.RESOURCE_COST
, CQL.OUTSIDE_PROCESSING_COST /* FOREIGN KEYS RESOLVED */
, MP.ORGANIZATION_CODE
, HR.NAME
, '_KF:INV:MSTK:SY' /* IDS */
, CQL.COST_GROUP_ID /* WHO */
, CQL.CREATION_DATE
, CQL.CREATED_BY
, CQL.LAST_UPDATE_DATE
, CQL.LAST_UPDATED_BY
FROM MTL_SYSTEM_ITEMS SY
, HR_ALL_ORGANIZATION_UNITS HR
, MTL_PARAMETERS MP
, CST_QUANTITY_LAYERS CQL
WHERE CQL.ORGANIZATION_ID = HR.ORGANIZATION_ID
AND CQL.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND SY.ORGANIZATION_ID = CQL.ORGANIZATION_ID
AND SY.INVENTORY_ITEM_ID = CQL.INVENTORY_ITEM_ID
AND '_SEC:CQL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY