I want to send the purchase orders to an external system from oracle by customization….i will be sending the po changes like need by date , price, quantity and shipment status . when ever there is a change in these four fields i have to send it to the external system.
the logic in my code is such that i am comparing max (revision num -1) in po line locations archive all with the record in po line locations all …and i am giving the last run condition of the program based on last_update_date in po line locations….but the query is picking up unwanted po's where there are changes other than these four fields
1.need_by_date
2.quantity
3.price
4.shipment_closure_status
please check the code and let me know what changes should i do in my package
APCX_SUPPLYON_CHANGED_PO_PKG.sql