CST_XLA_WIP_SVC_CST_REC_TXNS

Details

Schema: FUSION
Object owner: CST
Object type: VIEW

Columns

Name
DISTRIBUTION_ID COST_ORG_NAME COST_BOOK_CODE INVENTORY_ORGANIZATION WORK_ORDER_NUMBER OPERATION_SEQUENCE ITEM_RESOURCE QUANTITY UOM_CODE TRANSACTION_DATE VAL_UNIT_CODE TRANSACTION_TYPE_NAME

Name

DISTRIBUTION_ID

COST_ORG_NAME

COST_BOOK_CODE

INVENTORY_ORGANIZATION

WORK_ORDER_NUMBER

OPERATION_SEQUENCE

ITEM_RESOURCE

QUANTITY

UOM_CODE

TRANSACTION_DATE

VAL_UNIT_CODE

TRANSACTION_TYPE_NAME

Query

SQL_Statement
SELECT DISTINCT ccd.distribution_id, cco.cost_org_name cost_org_name, ccb.cost_book_code cost_book_code, hr.name inventory_organization, cwo.work_order_number work_order_number, cwoo.operation_seq_number operation_sequence, esi.item_number item_resource, ct.quantity quantity, uom.unit_of_measure uom_code, ct.transaction_date transaction_date, vu.val_unit_code val_unit_code, catv.base_txn_type_name transaction_type_name FROM cst_rcl_cost_rec_txns crcrt, cst_transactions ct, cst_cost_orgs_v cco, cst_cost_books_b ccb, hr_all_organization_units_tl hr, cst_work_orders cwo, cst_work_order_operations cwoo, egp_system_items_vl esi, inv_units_of_measure_vl uom, cst_val_units_vl vu, cst_cost_distributions ccd, cst_all_txn_types_v catv WHERE crcrt.cst_transaction_id = ct.transaction_id AND ccd.transaction_id = crcrt.transaction_id AND crcrt.source_table = 'cst_transactions' AND ct.cost_org_id = cco.cost_org_id AND ct.cost_book_id = ccb.cost_book_id AND ct.inventory_org_id = hr.organization_id AND userenv('LANG') = hr.language AND ct.cst_work_order_id = cwo.cst_work_order_id AND ct.cst_work_order_operation_id = cwoo.cst_work_order_operation_id AND ct.inventory_org_id = esi.organization_id AND ct.inventory_item_id = esi.inventory_item_id AND ct.val_unit_id = vu.val_unit_id AND crcrt.transaction_source_type_id = catv.base_txn_source_type_id AND crcrt.transaction_type_id = catv.base_txn_type_id AND crcrt.transaction_action_id = catv.base_txn_action_id AND ct.uom_code = uom.uom_code UNION ALL SELECT DISTINCT ccd.distribution_id distribution_id, cco.cost_org_name cost_org_name, ccb.cost_book_code cost_book_code, hr.name inventory_organization, cwo.work_order_number work_order_number, cwoo.operation_seq_number operation_sequence, wwr.resource_name item_resource, crt.primary_quantity quantity, uom.unit_of_measure uom_code, crt.transaction_date transaction_date, NULL val_unit_code, catv.base_txn_type_name transaction_type_name FROM cst_rcl_cost_rec_txns crcrt, cst_resource_transactions crt, cst_cost_orgs_v cco, cst_cost_books_b ccb, hr_all_organization_units_tl hr, cst_work_orders cwo, cst_work_order_operations cwoo, wis_resources_vl wwr, inv_units_of_measure_vl uom, cst_cost_distributions ccd, cst_all_txn_types_v catv WHERE crcrt.cst_transaction_id = crt.resource_transaction_id AND crcrt.source_table = 'cst_resource_transactions' AND ccd.transaction_id = crcrt.transaction_id AND crt.cost_org_id = cco.cost_org_id AND crt.cost_book_id = ccb.cost_book_id AND crt.inventory_organization_id = hr.organization_id AND userenv('LANG') = hr.language AND crt.cst_work_order_id = cwo.cst_work_order_id AND crt.cst_work_order_operation_id = cwoo.cst_work_order_operation_id AND crcrt.transaction_source_type_id = catv.base_txn_source_type_id AND crcrt.transaction_type_id = catv.base_txn_type_id AND crcrt.transaction_action_id = catv.base_txn_action_id AND crt.primary_uom_code = uom.uom_code AND wwr.resource_id = crt.resource_id

SQL_Statement

SELECT DISTINCT

ccd.distribution_id,

cco.cost_org_name cost_org_name,

ccb.cost_book_code cost_book_code,

hr.name inventory_organization,

cwo.work_order_number work_order_number,

cwoo.operation_seq_number operation_sequence,

esi.item_number item_resource,

ct.quantity quantity,

uom.unit_of_measure uom_code,

ct.transaction_date transaction_date,

vu.val_unit_code val_unit_code,

catv.base_txn_type_name transaction_type_name

FROM

cst_rcl_cost_rec_txns crcrt,

cst_transactions ct,

cst_cost_orgs_v cco,

cst_cost_books_b ccb,

hr_all_organization_units_tl hr,

cst_work_orders cwo,

cst_work_order_operations cwoo,

egp_system_items_vl esi,

inv_units_of_measure_vl uom,

cst_val_units_vl vu,

cst_cost_distributions ccd,

cst_all_txn_types_v catv

WHERE

crcrt.cst_transaction_id = ct.transaction_id

AND ccd.transaction_id = crcrt.transaction_id

AND crcrt.source_table = 'cst_transactions'

AND ct.cost_org_id = cco.cost_org_id

AND ct.cost_book_id = ccb.cost_book_id

AND ct.inventory_org_id = hr.organization_id

AND userenv('LANG') = hr.language

AND ct.cst_work_order_id = cwo.cst_work_order_id

AND ct.cst_work_order_operation_id = cwoo.cst_work_order_operation_id

AND ct.inventory_org_id = esi.organization_id

AND ct.inventory_item_id = esi.inventory_item_id

AND ct.val_unit_id = vu.val_unit_id

AND crcrt.transaction_source_type_id = catv.base_txn_source_type_id

AND crcrt.transaction_type_id = catv.base_txn_type_id

AND crcrt.transaction_action_id = catv.base_txn_action_id

AND ct.uom_code = uom.uom_code

UNION ALL

SELECT DISTINCT

ccd.distribution_id distribution_id,

cco.cost_org_name cost_org_name,

ccb.cost_book_code cost_book_code,

hr.name inventory_organization,

cwo.work_order_number work_order_number,

cwoo.operation_seq_number operation_sequence,

wwr.resource_name item_resource,

crt.primary_quantity quantity,

uom.unit_of_measure uom_code,

crt.transaction_date transaction_date,

NULL val_unit_code,

catv.base_txn_type_name transaction_type_name

FROM

cst_rcl_cost_rec_txns crcrt,

cst_resource_transactions crt,

cst_cost_orgs_v cco,

cst_cost_books_b ccb,

hr_all_organization_units_tl hr,

cst_work_orders cwo,

cst_work_order_operations cwoo,

wis_resources_vl wwr,

inv_units_of_measure_vl uom,

cst_cost_distributions ccd,

cst_all_txn_types_v catv

WHERE

crcrt.cst_transaction_id = crt.resource_transaction_id

AND crcrt.source_table = 'cst_resource_transactions'

AND ccd.transaction_id = crcrt.transaction_id

AND crt.cost_org_id = cco.cost_org_id

AND crt.cost_book_id = ccb.cost_book_id

AND crt.inventory_organization_id = hr.organization_id

AND userenv('LANG') = hr.language

AND crt.cst_work_order_id = cwo.cst_work_order_id

AND crt.cst_work_order_operation_id = cwoo.cst_work_order_operation_id

AND crcrt.transaction_source_type_id = catv.base_txn_source_type_id

AND crcrt.transaction_type_id = catv.base_txn_type_id

AND crcrt.transaction_action_id = catv.base_txn_action_id

AND crt.primary_uom_code = uom.uom_code

AND wwr.resource_id = crt.resource_id