CST_TXN_LAYER_DTLS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
TRANSACTION_ID REC_TRXN_ID DEP_TRXN_ID COST_ORG_ID COST_BOOK_ID VAL_UNIT_ID INVENTORY_ITEM_ID BUSINESS_UNIT_ID COST_DATE POSTED_FLAG INVENTORY_ORG_ID SUBINVENTORY_CODE LOCATOR_ID LOT_NUMBER GRADE_CODE SERIAL_NUMBER QUANTITY UOM_CODE TXN_SOURCE_DOC_NUMBER TXN_SOURCE_DOC_TYPE TXN_SOURCE_REF_DOC_NUMBER TXN_SOURCE_REF_DOC_TYPE EXPENSE_TRANSACTION_FLAG

Query

SQL_Statement

select ctl.transaction_id, ctl.rec_trxn_id, ctl.dep_trxn_id, ctl.cost_org_id, ctl.cost_book_id, ctl.val_unit_id, ctl.inventory_item_id, ct.business_unit_id, ctl.cost_date, ctl.posted_flag, cit.inventory_org_id, cit.subinventory_code, cit.locator_id, citd.lot_number, citd.grade_code, citd.serial_number, ctl.quantity, ctl.uom_code, ct.txn_source_doc_number, ct.txn_source_doc_type, ct.txn_source_ref_doc_number, ct.txn_source_ref_doc_type, ct.expense_transaction_flag from cst_transaction_layers ctl, cst_transactions ct, cst_inv_transactions cit, cst_inv_transaction_dtls citd where ctl.transaction_id = ct.transaction_id and ct.cst_inv_transaction_id = cit.cst_inv_transaction_id and ct.cst_inv_transaction_dtl_id = citd.cst_inv_transaction_dtl_id(+)