VIEW: APPS.CST_DEFAULT_DETAIL_COST_VIEW

Source

View Text - Preformatted

SELECT cct.cost_type_id, cia.cost_type_id, cia.organization_id, cia.inventory_item_id, cia.inventory_asset_flag, cia.lot_size, cia.based_on_rollup_flag, cia.shrinkage_rate, cia.defaulted_flag, cia.cost_update_id, cicd.operation_seq_num, cicd.department_id, cicd.level_type, cicd.activity_id, cicd.resource_seq_num, cicd.resource_id, cicd.resource_rate, cicd.item_units, cicd.activity_units, cicd.usage_rate_or_amount, cicd.basis_type, cicd.basis_resource_id, cicd.basis_factor, cicd.net_yield_or_shrinkage_factor, cicd.item_cost, cicd.cost_element_id, cicd.rollup_source_type, cicd.operation_sequence_id from cst_cost_types cct, cst_item_costs cia, cst_item_cost_details cicd WHERE CIA.ORGANIZATION_ID=NVL(CCT.ORGANIZATION_ID,CIA.ORGANIZATION_ID) AND ( (CIA.COST_TYPE_ID = CCT.COST_TYPE_ID) OR ( (CIA.COST_TYPE_ID = CCT.DEFAULT_COST_TYPE_ID) AND (NOT EXISTS (SELECT 'X' FROM CST_ITEM_COSTS CIA2 WHERE CIA2.INVENTORY_ITEM_ID = CIA.INVENTORY_ITEM_ID AND CIA2.ORGANIZATION_ID = CIA.ORGANIZATION_ID AND CIA2.COST_TYPE_ID = CCT.COST_TYPE_ID)) ) ) AND CICD.ORGANIZATION_ID (+) = CIA.ORGANIZATION_ID AND CICD.INVENTORY_ITEM_ID (+) = CIA.INVENTORY_ITEM_ID AND CICD.COST_TYPE_ID (+) = CIA.COST_TYPE_ID

View Text - HTML Formatted

SELECT CCT.COST_TYPE_ID
, CIA.COST_TYPE_ID
, CIA.ORGANIZATION_ID
, CIA.INVENTORY_ITEM_ID
, CIA.INVENTORY_ASSET_FLAG
, CIA.LOT_SIZE
, CIA.BASED_ON_ROLLUP_FLAG
, CIA.SHRINKAGE_RATE
, CIA.DEFAULTED_FLAG
, CIA.COST_UPDATE_ID
, CICD.OPERATION_SEQ_NUM
, CICD.DEPARTMENT_ID
, CICD.LEVEL_TYPE
, CICD.ACTIVITY_ID
, CICD.RESOURCE_SEQ_NUM
, CICD.RESOURCE_ID
, CICD.RESOURCE_RATE
, CICD.ITEM_UNITS
, CICD.ACTIVITY_UNITS
, CICD.USAGE_RATE_OR_AMOUNT
, CICD.BASIS_TYPE
, CICD.BASIS_RESOURCE_ID
, CICD.BASIS_FACTOR
, CICD.NET_YIELD_OR_SHRINKAGE_FACTOR
, CICD.ITEM_COST
, CICD.COST_ELEMENT_ID
, CICD.ROLLUP_SOURCE_TYPE
, CICD.OPERATION_SEQUENCE_ID
FROM CST_COST_TYPES CCT
, CST_ITEM_COSTS CIA
, CST_ITEM_COST_DETAILS CICD
WHERE CIA.ORGANIZATION_ID=NVL(CCT.ORGANIZATION_ID
, CIA.ORGANIZATION_ID)
AND ( (CIA.COST_TYPE_ID = CCT.COST_TYPE_ID) OR ( (CIA.COST_TYPE_ID = CCT.DEFAULT_COST_TYPE_ID)
AND (NOT EXISTS (SELECT 'X'
FROM CST_ITEM_COSTS CIA2
WHERE CIA2.INVENTORY_ITEM_ID = CIA.INVENTORY_ITEM_ID
AND CIA2.ORGANIZATION_ID = CIA.ORGANIZATION_ID
AND CIA2.COST_TYPE_ID = CCT.COST_TYPE_ID)) ) )
AND CICD.ORGANIZATION_ID (+) = CIA.ORGANIZATION_ID
AND CICD.INVENTORY_ITEM_ID (+) = CIA.INVENTORY_ITEM_ID
AND CICD.COST_TYPE_ID (+) = CIA.COST_TYPE_ID