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 ...
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
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
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 |
|
LOV |