DBA Data[Home] [Help]

APPS.JAI_PO_HA_TRIGGER_PKG dependencies on JAI_RCV_HEADERS

Line 492: Fix: In ARU_T3, added an update statement to jai_rcv_headers to update the vendor to the new vendor

488: 11. 10-Sep-2010 Jia for GST Bug#10091373
489:
490: 12. 06-06-2012 amandali for bug 14085523
491: Description:AFTER SUPPLIER MERGE OLD SUPPLIER IS DISPLAYED IN 'RECEIPT LOCALIZATION' WINDOW
492: Fix: In ARU_T3, added an update statement to jai_rcv_headers to update the vendor to the new vendor
493:
494: Future Dependencies For the release Of this Object:-
495: (Please add a row in the section below only if your bug introduces a dependency due to spec change/ A new call to a object/
496: A datamodel change )

Line 564: update jai_rcv_headers

560: where shipment_header_id = c_receipt_rec.shipment_header_id
561: and shipment_line_id = c_receipt_rec.shipment_line_id
562: and vendor_id = pr_old.vendor_id;
563: /* start -14085523 */
564: update jai_rcv_headers
565: set vendor_id = pr_new.vendor_id,
566: vendor_site_id = decode(vendor_site_id,pr_old.vendor_site_id, pr_new.vendor_site_id)
567: where shipment_header_id = c_receipt_rec.shipment_header_id
568: and vendor_id = pr_old.vendor_id;