CST_R_TXN_LAYERS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
TRANSACTION_ID REC_TRXN_ID DEP_TRXN_ID COST_ORGANIZATION_ID COST_BOOK_ID LEDGER_ID LEGAL_ENTITY_ID GL_DATE QUANTITY UOM_CODE VAL_UNIT_ID INVENTORY_ITEM_ID INVENTORY_ORG_ID TXN_SOURCE_REF_DOC_TYPE TXN_SOURCE_REF_DOC_NUMBER

Query

SQL_Statement

select cd.transaction_id, cd.rec_trxn_id, cd.dep_trxn_id, cd.cost_organization_id, cd.cost_book_id, cd.ledger_id, cd.legal_entity_id, cd.gl_date, ctl.quantity, ctl.uom_code, ctl.val_unit_id, ctl.inventory_item_id, ct.inventory_org_id, ct.txn_source_ref_doc_type, ct.txn_source_ref_doc_number from cst_cost_distributions cd, cst_transaction_layers ctl, cst_transactions ct where cd.accounted_flag = 'F' and cd.transaction_id = ctl.transaction_id and cd.rec_trxn_id = ctl.rec_trxn_id and cd.dep_trxn_id = ctl.dep_trxn_id and ct.transaction_id = cd.rec_trxn_id and ct.expense_transaction_flag = 'N'