DBA Data[Home] [Help]

APPS.PON_VENDORMERGE_GRP dependencies on AP_SUPPLIERS

Line 534: - Retrieve trading_partner_id from ap_suppliers and use that

530: l_progress := 301;
531: fnd_file.put_line (fnd_file.log, l_progress|| 'Start : MERGE_SAME_VENDOR_DIFF_SITES');
532:
533: /* Bug 4948321 : FTS for pon_bid_headers due to vendorId comparision.
534: - Retrieve trading_partner_id from ap_suppliers and use that
535: in update query for pon_bid_headers.
536: */
537:
538: SELECT party_id

Line 540: FROM ap_suppliers

536: */
537:
538: SELECT party_id
539: INTO l_trading_partner_id
540: FROM ap_suppliers
541: WHERE vendor_id=p_vendor_id;
542:
543: UPDATE pon_bid_headers pbh1
544: SET pbh1.vendor_site_id = p_vendor_site_id,