NEED A BI PUBLISHER SQL QUERY (SQL CODE) FOR INVENTORY TRANSACTIONS (See question)

@Lynn Warneka-Oracle

I need an OTBI SQL Query to fetch data for all Inventory transactions that exist in Oracle Fusion Cloud Inventory Management module. The SQL output should ideally have the below columns of data. Thanks in advance.

Organization Code,

Organization Name,

Transaction Number,

Transaction Date,

Item Number,

Item Description,

Transaction Type,

Quantity,

Source Sub-Inventory,

Source Locator,

Destination Sub-Inventory,

Destination Locator,

Cost Information (if available like Unit Cost, Transaction Cost etc..)

Reference Document (PO, TO, WO etc…),

Transaction Created By

@Lynn Warneka-Oracle @Manali Biswas-Oracle @Prasanth Senthivel-Oracle @Adriana Rivera @Karishma @JimCC @Christy Irimpan- Oracle-Oracle @Shabbir M Tahasildar @Sajid Khan Bangash @Mehmet K Erisen