CST_XLA_OPERATION_TXNS

Details

Schema: FUSION
Object owner: CST
Object type: VIEW

Columns

Name
OPERATION_TRANSACTION_ID COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID INV_ORG_ID CST_WORK_ORDER_ID CST_WORK_ORDER_OPERATION_ID WORK_CENTER_ID BASE_TXN_TYPE_ID BASE_TXN_SOURCE_TYPE_ID BASE_TXN_ACTION_ID COST_PROFILE_ID UOM_CODE CST_WO_OPERATION_TXN_ID TXN_SOURCE_DOC_TYPE TXN_SOURCE_DOC_NUMBER TXN_SOURCE_REF_DOC_TYPE TXN_SOURCE_REF_DOC_NUMBER SCRAP_REASON_CODE OPERATION_SCRAP_COST_TYPE OPERATION_SCRAP_VALUATION_TYPE ASSEMBLY_ASSET_ID

Name

OPERATION_TRANSACTION_ID

COST_ORG_ID

COST_BOOK_ID

INVENTORY_ITEM_ID

INV_ORG_ID

CST_WORK_ORDER_ID

CST_WORK_ORDER_OPERATION_ID

WORK_CENTER_ID

BASE_TXN_TYPE_ID

BASE_TXN_SOURCE_TYPE_ID

BASE_TXN_ACTION_ID

COST_PROFILE_ID

UOM_CODE

CST_WO_OPERATION_TXN_ID

TXN_SOURCE_DOC_TYPE

TXN_SOURCE_DOC_NUMBER

TXN_SOURCE_REF_DOC_TYPE

TXN_SOURCE_REF_DOC_NUMBER

SCRAP_REASON_CODE

OPERATION_SCRAP_COST_TYPE

OPERATION_SCRAP_VALUATION_TYPE

ASSEMBLY_ASSET_ID

Query

SQL_Statement
SELECT cot.operation_transaction_id operation_transaction_id, cot.cost_org_id cost_org_id, cot.cost_book_id cost_book_id, cot.inventory_item_id inventory_item_id, cot.inventory_organization_id inv_org_id, cot.cst_work_order_id cst_work_order_id, cot.cst_work_order_operation_id cst_work_order_operation_id, cot.work_center_id work_center_id, cot.base_txn_type_id base_txn_type_id, cot.base_txn_source_type_id base_txn_source_type_id, cot.base_txn_action_id base_txn_action_id, cot.cost_profile_id cost_profile_id, cot.primary_uom_code uom_code, cot.cst_wo_operation_txn_id cst_wo_operation_txn_id, cot.txn_source_doc_type txn_source_doc_type, cot.txn_source_doc_number txn_source_doc_number, cot.txn_source_ref_doc_type txn_source_ref_doc_type, cot.txn_source_ref_doc_number txn_source_ref_doc_number, cot.reason_code scrap_reason_code, cot.operation_scrap_cost_type operation_scrap_cost_type, cot.operation_scrap_valuation_type operation_scrap_valuation_type, wo.min_asset_id assembly_asset_id FROM cst_operation_transactions cot, ( SELECT cst_work_order_id, MIN(asset_id) min_asset_id FROM cst_work_orders cwo, wie_wo_assets wwa WHERE cwo.external_system_ref_id = wwa.work_order_id GROUP BY cst_work_order_id ) wo WHERE cot.cst_work_order_id = wo.cst_work_order_id (+)

SQL_Statement

SELECT cot.operation_transaction_id operation_transaction_id,

cot.cost_org_id cost_org_id,

cot.cost_book_id cost_book_id,

cot.inventory_item_id inventory_item_id,

cot.inventory_organization_id inv_org_id,

cot.cst_work_order_id cst_work_order_id,

cot.cst_work_order_operation_id cst_work_order_operation_id,

cot.work_center_id work_center_id,

cot.base_txn_type_id base_txn_type_id,

cot.base_txn_source_type_id base_txn_source_type_id,

cot.base_txn_action_id base_txn_action_id,

cot.cost_profile_id cost_profile_id,

cot.primary_uom_code uom_code,

cot.cst_wo_operation_txn_id cst_wo_operation_txn_id,

cot.txn_source_doc_type txn_source_doc_type,

cot.txn_source_doc_number txn_source_doc_number,

cot.txn_source_ref_doc_type txn_source_ref_doc_type,

cot.txn_source_ref_doc_number txn_source_ref_doc_number,

cot.reason_code scrap_reason_code,

cot.operation_scrap_cost_type operation_scrap_cost_type,

cot.operation_scrap_valuation_type operation_scrap_valuation_type,

wo.min_asset_id assembly_asset_id

FROM cst_operation_transactions cot,

(

SELECT

cst_work_order_id,

MIN(asset_id) min_asset_id

FROM

cst_work_orders cwo,

wie_wo_assets wwa

WHERE

cwo.external_system_ref_id = wwa.work_order_id

GROUP BY

cst_work_order_id

) wo

WHERE

cot.cst_work_order_id = wo.cst_work_order_id (+)