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  ... 
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 will not be processed.
3) Asset is updated from Oracle Asset which caused asset status, location out of sync with OAT record.
Erro message - 'Prior transactions are in pending status for this item instance. Please process them first before processing this one.' you will need find out which is the 'Prior transactions'
You can always go to the transaction's related instances and find out which is the earlier pending transaction using following query
   more
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
Parameter Name SQL text Validation
Pending Transaction
citd.transaction_id=:txn_id
LOV