CST_COSTED_INTR_TXN_COSTS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
TXN_SOURCE_REF_DOC_NUMBER TXN_SOURCE_REF_DOC_TYPE TXN_SOURCE_DOC_NUMBER TXN_SOURCE_DOC_TYPE TRANSFER_TXN_ID TRANSACTION_FLOW_TYPE COST_ORG_ID COST_BOOK_ID INVENTORY_ORG_ID INVENTORY_ITEM_ID COST_ELEMENT_ID SNAPSHOT_DATE EFF_TO_DATE ONHAND_VALUE ACCTD_ONHAND_VALUE CURRENCY_CODE UOM_CODE COST_METHOD_CODE EXPENSE_TRANSACTION_FLAG CONSIGNED_FLAG

Query

SQL_Statement

SELECT cast(NULL as VARCHAR2(240)) txn_source_ref_doc_number, cast(NULL as VARCHAR2(50)) txn_source_ref_doc_type, cast(NULL as VARCHAR2(240)) txn_source_doc_number, cast(NULL as VARCHAR2(50)) txn_source_doc_type, cast(NULL as NUMBER) transfer_txn_id, cast(NULL as NUMBER) transaction_flow_type, cast(NULL as NUMBER(18)) cost_org_id, cast(NULL as NUMBER(18)) cost_book_id, cast(NULL as NUMBER(18)) inventory_org_id, cast(NULL as NUMBER(18)) inventory_item_id, cast(NULL as NUMBER(18)) cost_element_id, cast(NULL as DATE) snapshot_date, cast(NULL as DATE) eff_to_date, cast(NULL as NUMBER) onhand_value, cast(NULL as NUMBER) acctd_onhand_value, cast(NULL as VARCHAR2(30)) currency_code, cast(NULL as VARCHAR2(3)) uom_code, cast(NULL as VARCHAR2(30)) cost_method_code, cast(NULL as VARCHAR2(1)) expense_transaction_flag, cast(NULL as VARCHAR2(1)) consigned_flag FROM cst_b_costed_intr_txn_costs_v WHERE 1=2