CST_ACCT_TXN_LAYER_DTLS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
TRANSACTION_ID REC_TRXN_ID DEP_TRXN_ID LEDGER_ID LEGAL_ENTITY_ID GL_DATE COST_ORG_ID COST_BOOK_ID VAL_UNIT_ID INVENTORY_ITEM_ID BUSINESS_UNIT_ID COST_DATE 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 cd.transaction_id, cd.rec_trxn_id, cd.dep_trxn_id, cd.ledger_id, cd.legal_entity_id, cd.gl_date, ctl.cost_org_id, ctl.cost_book_id, ctl.val_unit_id, ctl.inventory_item_id, ct.business_unit_id, ctl.cost_date, 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 (select a.transaction_id, a.rec_trxn_id, a.dep_trxn_id, a.ledger_id, a.legal_entity_id, a.gl_date from (select transaction_id, rec_trxn_id, dep_trxn_id, ledger_id, legal_entity_id, gl_date, min(gl_date) OVER(PARTITION BY transaction_id, rec_trxn_id, dep_trxn_id) min_date from cst_cost_distributions cd where accounted_flag = 'F') a where a.gl_date = a.min_date) cd, cst_transaction_layers ctl, cst_transactions ct, cst_inv_transactions cit, cst_inv_transaction_dtls citd where 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 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(+)