CSI Asset Tracking listing of pending transactions with specific transaction ID parameter

Description

Categories: Draft
Columns: Instance Id, Transaction Id, Transaction Date, Inv Material Transaction Id, Txn Sub Type Id, Source Txn Type Name, Fa Asset Id, Asset Quantity, Active End Date, Ib Fa Location ...

When a transaction is successfully interfaced to Oracle Assets, the transaction's status will be updated from 'PENDING' to 'COMPLETE'. The majority reasons are:
1) OAT related set ups are not completed/correct, e.g asset category, asset location, asset name.
2) Previous transaction for the same asset is still in pending, e.g. asset is not created by create asset program so move transaction ... more

Copy

SELECT citd.instance_id,
                      citd.transaction_id,
                      citd.transaction_date,
                      citd.inv_material_transaction_id,
                      citd.txn_sub_type_id,
                      citd.source_txn_type_name,
                      cia.fa_asset_id,
                      cia.asset_quantity,
                      cia.active_end_date ,
                      cia.fa_location_id IB_fa_location,
                      cia.fa_sync_flag,
                      cia.active_end_date
             FROM csi_inst_txn_details_v citd,
                     csi_i_assets cia,
                     csi_inst_txn_details_v citd2
           WHERE 1=1
              AND citd2.instance_id      = citd.instance_id
              AND cia.instance_id (+)    = citd.instance_id
           ORDER BY 1, 2