1. Tables and Views for SCM
  2. CST_XLA_CONS_COST_ADJ_TXNS_V

CST_XLA_CONS_COST_ADJ_TXNS_V

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: VIEW

Columns

Name

DISTRIBUTION_ID

COST_ORG_NAME

COST_BOOK_CODE

ITEM_NUMBER

QUANTITY

UOM_CODE

TRANSACTION_DATE

VAL_UNIT_CODE

TRANSACTION_SOURCE

TRANSACTION_REFERENCE

Query

SQL_Statement

SELECT DISTINCT ccd.distribution_id distribution_id,

cco.cost_org_name cost_org_name ,

ccb.cost_book_code cost_book_code ,

esi.item_number item_number ,

ct.quantity quantity ,

iuom.unit_of_measure uom_code ,

ct.transaction_date transaction_date ,

cvu.val_unit_code val_unit_code ,

'Consigned Cost Adjustment' transaction_source ,

'Reference' transaction_reference

FROM cst_transactions ct ,

cst_cost_orgs_v cco ,

cst_cost_books_b ccb ,

cst_val_units_b cvu ,

egp_system_items_vl esi ,

cst_cost_org_parameters ccop,

cst_cost_distributions ccd,

inv_units_of_measure_vl iuom

WHERE ct.cost_org_id = cco.cost_org_id

AND ccop.cost_org_id = ct.cost_org_id

AND ct.cost_book_id = ccb.cost_book_id

AND ct.val_unit_id = cvu.val_unit_id

AND esi.inventory_item_id = ct.inventory_item_id

AND esi.organization_id = ccop.master_organization_id

AND ct.transaction_id = ccd.transaction_id

AND iuom.uom_code = ct.uom_code

AND ct.base_txn_type_id IN (18,71)

AND ct.base_txn_source_type_id = 1

AND ct.base_txn_action_id IN (27,29)

AND ct.consigned_flag = 'Y'