CST_XLA_INV_TRANSACTIONS_V

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: VIEW

Columns

Name

CST_INV_TRANSACTION_ID

EXTERNAL_SYSTEM_REFERENCE

EXTERNAL_SYSTEM_REF_ID

SUBINVENTORY_CODE

LOCATOR_ID

TRANSACTION_REASON_ID

TRANSFER_INV_ORG_ID

TRANSFER_SUBINVENTORY_CODE

TRANSFER_LOCATOR_ID

INTERCOMPANY_INVOICING_FLAG

RCV_TRANSACTION_ID

PO_DISTRIBUTION_ID

WSH_DELIVERY_DETAIL_ID

DOO_FULLFILL_LINE_ID

TRANSACTION_UOM_CODE

PRIMARY_UOM_CODE

SECONDARY_TRANSACTION_UOM_CODE

Query

SQL_Statement

SELECT cst_inv_transaction_id cst_inv_transaction_id

, external_system_reference external_system_reference

, external_system_ref_id external_system_ref_id

, subinventory_code subinventory_code

, locator_id locator_id

, transaction_reason_id transaction_reason_id

, transfer_inventory_org_id transfer_inv_org_id

, transfer_subinventory_code transfer_subinventory_code

, transfer_locator_id transfer_locator_id

, intercompany_invoicing_flag intercompany_invoicing_flag

, rcv_transaction_id rcv_transaction_id

, po_distribution_id po_distribution_id

, wsh_delivery_detail_id wsh_delivery_detail_id

, doo_fullfill_line_id doo_fullfill_line_id

, transaction_uom_code transaction_uom_code

, primary_uom_code primary_uom_code

, secondary_transaction_uom_code secondary_transaction_uom_code

FROM cst_inv_transactions