Skip to main content

Logical and Relational Data Model Diagrams for Fusion Applications

Labels:

Comments

Post a Comment

Popular posts from this blog

Important Tables and Views in Oracle Fusion Inventory

INV_ORG_PARAMETERS INV_ITEM_LOCATIONS INV_PHYSICAL_INVENTORIES INV_SECONDARY_INVENTORIES INV_SECONDARY_LOCATORS INV_ORGANIZATION_DEFINITIONS_V INV_ONHAND_QUANTITIES_DETAIL INV_RULES_VL INV_ACTIONS_VL INV_SERIAL_NUMBERS INV_LOT_NUMBERS INV_UNITS_OF_MEASURES_B INV_MATERIAL_STATUSES_TL INV_TRANSACTION_TYPES_TL INV_MATERIAL_TXNS INV_SALES_ORDERS INV_TXN_SOURCE_TYPES_TL INV_TXN_REQUEST_HEADERS INV_TRANSFER_ORDER_HEADERA INV_TRANSFER_ORDER_LINES INV_TRANSFER_ORDER_DISTRIBS
Post a Comment
Read more

Useful Views in Fusion Receivables

AR_TRX_INFO_V SELECT trx.customer_trx_id CUSTOMER_TRX_ID, pty.party_name CUSTOMER_NAME, ca.account_number CUSTOMER_NUMBER, trx.trx_number TRX_NUMBER, trx.doc_sequence_value TRX_DOCUMENT_NUMBER, trx.trx_date TRX_DATE, tty.name TRX_TYPE, bs.name TRX_BATCH_SOURCE, bu.bu_name BU_NAME FROM ra_customer_trx_all trx , hz_cust_accounts ca , hz_parties pty , ra_cust_trx_types_all tty, ra_batch_sources_all bs, fun_all_business_units_v bu WHERE DECODE(trx.drawee_id, NULL, trx.bill_to_customer_id, trx.drawee_id) = ca.cust_account_id AND ca.party_id = pty.party_id AND trx.cust_trx_type_seq_id = tty.cust_trx_type_seq_id AND trx.batch_source_seq_id = bs.batch_source_seq_id AND trx.org_id = bu.bu_id AR_CR_INFO_V SELECT cr.cash_receipt_id , pty.party_name , ca.account_number , cr.receipt_number , cr.doc_sequence_value, cr.receipt_date , arm.NAME , bu.bu_name FROM ar_cash_receipts_all cr, hz_cust_accounts ca , hz_parties pty ,...
Read more