CST_TRANSACTION_COSTS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name

TRANSACTION_COST_ID TRANSACTION_ID COST_DATE EFF_DATE COST_ELEMENT_ID COST_ELEMENT_CODE EXPENSE_POOL_ID EXPENSE_POOL_CODE UNIT_COST CURRENCY_CODE COST_ORG_ID COST_ORG_CODE COST_BOOK_ID COST_BOOK_CODE INVENTORY_ITEM_ID ITEM_NUMBER INVENTORY_ORG_ID ORGANIZATION_CODE VAL_UNIT_ID VAL_UNIT_CODE COST_TRANSACTION_TYPE ADDITIONAL_PROCESSING_CODE COST_METHOD_CODE ABSORPTION_TYPE POSTED_FLAG QUANTITY_ONHAND PERPAVG_COST_ID BASE_TXN_TYPE_ID BASE_TXN_SOURCE_TYPE_ID BASE_TXN_ACTION_ID BASE_TXN_TYPE_NAME ORIG_TXN_TYPE_ID ORIG_TXN_SOURCE_TYPE_ID ORIG_TXN_ACTION_ID ORIG_TXN_TYPE_NAME CST_INV_TRANSACTION_ID ADJUSTMENT_TRANSACTION_ID USER_ADJUSTMENT_ID ADJUSTMENT_DATE VALID_COST_FLAG OVERHEAD_GROUP_ID TXN_UNIT_COST TXN_CURRENCY_CODE TXN_CURR_CONV_TYPE TXN_CURR_CONV_DATE TXN_CURR_CONV_RATE COST_SOURCE COST_REFERENCE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE OVERHEAD_ID COSTED_QTY COSTING_UOM_CODE COSTING_STATUS ACCOUNTING_STATUS CODE_COMBINATION_ID

Query

SQL_Statement

SELECT b.transaction_cost_id, b.transaction_id, decode(z.cost_transaction_type,'ADJUST',b.cost_date,a.cost_date) cost_date, b.eff_date, b.cost_element_id, e.cost_element_code, b.expense_pool_id, h.expense_pool_code, b.unit_cost, b.currency_code, a.cost_org_id, c.cost_org_code, a.cost_book_id, d.cost_book_code, a.inventory_item_id, x.item_number, a.inventory_org_id, y.organization_code, a.val_unit_id, f.val_unit_code, a.cost_transaction_type, a.additional_processing_code, a.cost_method_code, b.absorption_type, b.posted_flag, b.quantity_onhand, b.perpavg_cost_id, b.base_txn_type_id, b.base_txn_source_type_id, b.base_txn_action_id, g.base_txn_type_name, a.base_txn_type_id AS orig_txn_type_id, a.base_txn_source_type_id AS orig_txn_source_type_id, a.base_txn_action_id AS orig_txn_action_id, i.base_txn_type_name AS orig_txn_type_name, b.cst_inv_transaction_id, b.adjustment_transaction_id, b.user_adjustment_id, b.adjustment_date, b.valid_cost_flag, b.overhead_group_id, b.txn_unit_cost, b.txn_currency_code, b.txn_currency_conversion_type AS txn_curr_conv_type, b.txn_currency_conversion_date AS txn_curr_conv_date, b.txn_currency_conversion_rate AS txn_curr_conv_rate, b.cost_source, b.cost_reference, b.created_by, b.creation_date, b.last_updated_by, b.last_update_date, b.last_update_login, b.request_id, b.job_definition_name, b.job_definition_package, b.overhead_id, b.costed_qty, b.costing_uom_code, b.costing_status, b.accounting_status, b.code_combination_id FROM cst_transactions a, cst_transaction_costs b, cst_cost_orgs_v c, cst_cost_books_b d, cst_cost_elements_b e, cst_val_units_b f, cst_all_txn_types_v g, cst_expense_pools_b h, cst_all_txn_types_v i, egp_system_items_b_v x, inv_org_parameters y, cst_txn_source_actions z WHERE a.transaction_id = b.transaction_id AND b.expense_pool_id <> -5 AND a.cost_org_id = c.cost_org_id (+) AND a.cost_book_id = d.cost_book_id (+) AND b.cost_element_id = e.cost_element_id (+) AND a.val_unit_id = f.val_unit_id (+) AND a.val_structure_id = f.val_structure_id (+) AND b.base_txn_type_id = g.base_txn_type_id (+) AND b.base_txn_source_type_id = g.base_txn_source_type_id (+) AND b.base_txn_action_id = g.base_txn_action_id (+) AND b.expense_pool_id = h.expense_pool_id (+) AND a.base_txn_type_id = i.base_txn_type_id (+) AND a.base_txn_source_type_id = i.base_txn_source_type_id (+) AND a.base_txn_action_id = i.base_txn_action_id (+) AND a.inventory_org_id = x.organization_id (+) AND a.inventory_item_id = x.inventory_item_id (+) AND a.inventory_org_id = y.organization_id (+) AND b.base_txn_source_type_id = z.base_txn_source_type_id (+) AND b.base_txn_action_id = z.base_txn_action_id (+)