Skip to main content

Important Tables and Views in Oracle Fusion Inventory


  1. INV_ORG_PARAMETERS
  2. INV_ITEM_LOCATIONS
  3. INV_PHYSICAL_INVENTORIES
  4. INV_SECONDARY_INVENTORIES
  5. INV_SECONDARY_LOCATORS
  6. INV_ORGANIZATION_DEFINITIONS_V
  7. INV_ONHAND_QUANTITIES_DETAIL
  8. INV_RULES_VL
  9. INV_ACTIONS_VL
  10. INV_SERIAL_NUMBERS
  11. INV_LOT_NUMBERS
  12. INV_UNITS_OF_MEASURES_B
  13. INV_MATERIAL_STATUSES_TL
  14. INV_TRANSACTION_TYPES_TL
  15. INV_MATERIAL_TXNS
  16. INV_SALES_ORDERS
  17. INV_TXN_SOURCE_TYPES_TL
  18. INV_TXN_REQUEST_HEADERS
  19. INV_TRANSFER_ORDER_HEADERA
  20. INV_TRANSFER_ORDER_LINES
  21. INV_TRANSFER_ORDER_DISTRIBS
Labels:

Comments

Post a Comment

Popular posts from this blog

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