CST_XLA_WIP_VARIANCE_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 TRANSACTION_TYPE VARIANCE_TYPE ITEM_NUMBER QUANTITY UOM_CODE TRANSACTION_DATE

Name

DISTRIBUTION_ID

COST_ORG_NAME

COST_BOOK_CODE

INVENTORY_ORGANIZATION

WORK_ORDER_NUMBER

TRANSACTION_TYPE

VARIANCE_TYPE

ITEM_NUMBER

QUANTITY

UOM_CODE

TRANSACTION_DATE

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, ctt.base_txn_type_name transaction_type, ccv.variance_group variance_type, esi.item_number item_number, ccv.quantity quantity, uom.unit_of_measure uom_code, uet.transaction_date transaction_date FROM cst_wo_update_event_txns uet, cst_wo_cost_variances ccv, cst_cost_orgs_v cco, cst_cost_books_vl ccb, hr_all_organization_units_tl hr, cst_work_orders cwo, egp_system_items_vl esi, inv_units_of_measure_vl uom, cst_cost_distributions ccd, cst_internal_txn_types_vl ctt WHERE ccd.distribution_id = ccv.distribution_id AND uet.wo_update_event_txn_id = ccv.wo_update_event_txn_id AND uet.cost_org_id = cco.cost_org_id AND uet.cost_book_id = ccb.cost_book_id AND uet.inventory_organization_id = hr.organization_id AND userenv('LANG') = hr.language AND uet.cst_work_order_id = cwo.cst_work_order_id AND uet.inventory_organization_id = esi.organization_id AND uet.inventory_item_id = esi.inventory_item_id AND uet.uom_code = uom.uom_code (+) AND uet.base_txn_source_type_id = ctt.base_txn_source_type_id AND uet.base_txn_action_id = ctt.base_txn_action_id AND uet.base_txn_type_id = ctt.base_txn_type_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,

ctt.base_txn_type_name transaction_type,

ccv.variance_group variance_type,

esi.item_number item_number,

ccv.quantity quantity,

uom.unit_of_measure uom_code,

uet.transaction_date transaction_date

FROM

cst_wo_update_event_txns uet,

cst_wo_cost_variances ccv,

cst_cost_orgs_v cco,

cst_cost_books_vl ccb,

hr_all_organization_units_tl hr,

cst_work_orders cwo,

egp_system_items_vl esi,

inv_units_of_measure_vl uom,

cst_cost_distributions ccd,

cst_internal_txn_types_vl ctt

WHERE

ccd.distribution_id = ccv.distribution_id

AND uet.wo_update_event_txn_id = ccv.wo_update_event_txn_id

AND uet.cost_org_id = cco.cost_org_id

AND uet.cost_book_id = ccb.cost_book_id

AND uet.inventory_organization_id = hr.organization_id

AND userenv('LANG') = hr.language

AND uet.cst_work_order_id = cwo.cst_work_order_id

AND uet.inventory_organization_id = esi.organization_id

AND uet.inventory_item_id = esi.inventory_item_id

AND uet.uom_code = uom.uom_code (+)

AND uet.base_txn_source_type_id = ctt.base_txn_source_type_id

AND uet.base_txn_action_id = ctt.base_txn_action_id

AND uet.base_txn_type_id = ctt.base_txn_type_id