1. Tables and Views for SCM
  2. CST_COSTED_TRANSACTIONS_V

CST_COSTED_TRANSACTIONS_V

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: VIEW

Columns

Name

TRANSACTION_ID

REC_TRXN_ID

DEP_TRXN_ID

TRANSACTION_COST_ID

EXPENSE_POOL_ID

COST_ID

EFF_DATE

COST_ORG_ID

COST_BOOK_ID

INVENTORY_ITEM_ID

VAL_UNIT_ID

BASE_TXN_TYPE_ID

COST_TRANSACTION_TYPE

ADDITIONAL_PROCESSING_CODE

UOM_CODE

CURRENCY_CODE

COST_ELEMENT_ID

UNIT_COST

QUANTITY

COST_DATE

POSTED_FLAG

SOURCE_TABLE

LAST_UPDATE_DATE

DISTRIBUTION_ID

ENTITY_CODE

ACCOUNTED_FLAG

Query

SQL_Statement

SELECT

CostedTransCostEO.transaction_id,

CostedTransCostEO.rec_trxn_id,

CostedTransCostEO.dep_trxn_id,

CostedTransCostEO.transaction_cost_id,

CostedTransCostEO.expense_pool_id,

CostedTransCostEO.cost_id,

CostedTransCostEO.eff_date,

CostedTransCostEO.cost_org_id,

CostedTransCostEO.cost_book_id,

CostedTransCostEO.inventory_item_id,

CostedTransCostEO.val_unit_id,

CostedTransCostEO.base_txn_type_id,

CostedTransCostEO.cost_transaction_type,

CostedTransCostEO.additional_processing_code,

CostedTransCostEO.uom_code,

CostedTransCostEO.currency_code,

CostedTransCostEO.cost_element_id,

CostedTransCostEO.unit_cost,

CostedTransCostEO.quantity,

CostedTransCostEO.cost_date,

CostedTransCostEO.posted_flag,

CostedTransCostEO.source_table,

CostedTransCostEO.last_update_date ,

CostedTransCostEO.distribution_id,

CostDistributionsEO.entity_code,

CostDistributionsEO.accounted_flag

FROM

((

SELECT

WriteoffCosts.transaction_id,

WriteoffCosts.rec_trxn_id,

WriteoffCosts.dep_trxn_id,

WriteoffCosts.transaction_cost_id,

WriteoffCosts.expense_pool_id,

WriteoffCosts.writeoff_cost_id cost_id,

WriteoffCosts.eff_date,

WriteoffCosts.cost_org_id,

WriteoffCosts.cost_book_id,

WriteoffCosts.inventory_item_id,

WriteoffCosts.val_unit_id,

WriteoffCosts.cost_date,

WriteoffCosts.base_txn_type_id,

WriteoffCosts.cost_transaction_type,

WriteoffCosts.additional_processing_code,

WriteoffCosts.quantity,

WriteoffCosts.uom_code,

WriteoffCosts.cost_element_id,

WriteoffCosts.unit_cost,

WriteoffCosts.currency_code,

WriteoffCosts.posted_flag,

'cst_writeoff_cost' source_table,

WriteoffCosts.distribution_id,

WriteoffCosts.last_update_date

FROM

cst_writeoff_costs WriteoffCosts

where posted_flag!= 'X'

)

UNION ALL

(

SELECT

Layercosts.transaction_id,

Layercosts.rec_trxn_id,

Layercosts.dep_trxn_id,

Layercosts.transaction_cost_id,

Layercosts.expense_pool_id,

Layercosts.layer_cost_id cost_id,

Layercosts.eff_date,

Layercosts.cost_org_id,

Layercosts.cost_book_id,

Layercosts.inventory_item_id,

Layercosts.val_unit_id,

Layercosts.cost_date,

Layercosts.base_txn_type_id,

Layercosts.cost_transaction_type,

Layercosts.additional_processing_code,

Layercosts.quantity,

Layercosts.uom_code,

Layercosts.cost_element_id,

Layercosts.unit_cost,

Layercosts.currency_code,

Layercosts.posted_flag,

'cst_layer_cost' source_table,

Layercosts.distribution_id,

Layercosts.last_update_date

FROM

cst_layer_costs Layercosts

where posted_flag!= 'X'

)

UNION ALL

(

SELECT

TransferCosts.transaction_id,

TransferCosts.rec_trxn_id,

TransferCosts.dep_trxn_id,

TransferCosts.transaction_cost_id,

TransferCosts.expense_pool_id,

TransferCosts.transfer_cost_id cost_id,

TransferCosts.eff_date,

TransferCosts.cost_org_id,

TransferCosts.cost_book_id,

TransferCosts.inventory_item_id,

TransferCosts.val_unit_id,

TransferCosts.cost_date,

TransferCosts.base_txn_type_id,

TransferCosts.cost_transaction_type,

TransferCosts.additional_processing_code,

TransferCosts.quantity,

TransferCosts.uom_code,

TransferCosts.cost_element_id,

TransferCosts.unit_cost,

TransferCosts.currency_code,

TransferCosts.posted_flag,

'cst_transfer_cost' source_table,

TransferCosts.distribution_id,

TransferCosts.last_update_date

FROM

cst_transfer_costs TransferCosts

where posted_flag!= 'X'

)) CostedTransCostEO,

cst_cost_distributions CostDistributionsEO

WHERE

CostedTransCostEO.distribution_id = CostDistributionsEO.distribution_id(+)