eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_VENDORMERGE_GRP dependencies on PON_PARTY_LINE_EXCLUSIONS

Line 526: 3. pon_party_line_exclusions

522: /*
523: Followling table will be updated while merging at SITE Level.
524: 1. pon_bid_headers
525: 2. pon_bidding_parties
526: 3. pon_party_line_exclusions
527: 4. pon_pf_supplier_formula
528: */
529:
530: l_progress := 301;

Line 599: UPDATE pon_party_line_exclusions pple1

595:
596: l_progress := 303;
597: fnd_file.put_line (fnd_file.log, l_progress|| 'Done : pon_bidding_parties');
598:
599: UPDATE pon_party_line_exclusions pple1
600: SET pple1.vendor_site_id = p_vendor_site_id,
601: pple1.last_updated_by = -1,
602: pple1.last_update_date = sysdate
603: WHERE pple1.vendor_site_id = p_dup_vendor_site_id

Line 605: FROM pon_party_line_exclusions pple2

601: pple1.last_updated_by = -1,
602: pple1.last_update_date = sysdate
603: WHERE pple1.vendor_site_id = p_dup_vendor_site_id
604: AND NOT EXISTS (SELECT 'DUPLICATE'
605: FROM pon_party_line_exclusions pple2
606: WHERE pple2.auction_header_id = pple1.auction_header_id
607: AND pple2.line_number = pple1.line_number
608: AND pple2.trading_partner_id = pple1.trading_partner_id
609: AND pple2.vendor_site_id = p_vendor_site_id);

Line 612: fnd_file.put_line (fnd_file.log, l_progress|| 'Done : pon_party_line_exclusions');

608: AND pple2.trading_partner_id = pple1.trading_partner_id
609: AND pple2.vendor_site_id = p_vendor_site_id);
610:
611: l_progress := 304;
612: fnd_file.put_line (fnd_file.log, l_progress|| 'Done : pon_party_line_exclusions');
613:
614: UPDATE pon_pf_supplier_formula ppsf1
615: SET ppsf1.vendor_site_id = p_vendor_site_id
616: WHERE ppsf1.vendor_site_id = p_dup_vendor_site_id

Line 676: 4. pon_party_line_exclusions

672: Followling table will be updated while merging at Vendor level.
673: 1. pon_bid_item_prices
674: 2. pon_bid_headers
675: 3. pon_bidding_parties
676: 4. pon_party_line_exclusions
677: 5. pon_pf_supplier_formula
678: */
679:
680: l_progress := 500;

Line 769: UPDATE pon_party_line_exclusions pple1

765:
766: l_progress := 503;
767: fnd_file.put_line (fnd_file.log, l_progress|| ' Done: pon_bidding_parties');
768:
769: UPDATE pon_party_line_exclusions pple1
770: SET pple1.trading_partner_id = p_trading_partner_id,
771: pple1.vendor_site_id = p_vendor_site_id,
772: pple1.last_updated_by = -1,
773: pple1.last_update_date = sysdate

Line 777: FROM pon_party_line_exclusions pple2

773: pple1.last_update_date = sysdate
774: WHERE pple1.trading_partner_id = p_dup_trading_partner_id
775: AND pple1.vendor_site_id = p_dup_vendor_site_id
776: AND NOT EXISTS (SELECT 'DUPLICATE'
777: FROM pon_party_line_exclusions pple2
778: WHERE pple2.auction_header_id = pple1.auction_header_id
779: AND pple2.trading_partner_id = p_trading_partner_id
780: AND pple2.vendor_site_id =p_vendor_site_id);
781:

Line 783: fnd_file.put_line (fnd_file.log, l_progress|| ' Done: pon_party_line_exclusions');

779: AND pple2.trading_partner_id = p_trading_partner_id
780: AND pple2.vendor_site_id =p_vendor_site_id);
781:
782: l_progress := 505;
783: fnd_file.put_line (fnd_file.log, l_progress|| ' Done: pon_party_line_exclusions');
784:
785: UPDATE pon_pf_supplier_formula ppsf1
786: SET ppsf1.trading_partner_id = p_trading_partner_id,
787: ppsf1.vendor_site_id = p_vendor_site_id,

Line 850: 4. pon_party_line_exclusions

846:
847: 1. pon_bid_item_prices
848: 2. pon_bid_headers
849: 3. pon_bidding_parties
850: 4. pon_party_line_exclusions
851: 5. pon_pf_supplier_formula
852: 6. pon_supplier_access
853: 7. pon_threads
854: 8. pon_thread_entries

Line 956: UPDATE pon_party_line_exclusions pple1

952:
953: l_progress := 705;
954: fnd_file.put_line (fnd_file.log, l_progress|| 'Done pon_bidding_parties');
955:
956: UPDATE pon_party_line_exclusions pple1
957: SET pple1.trading_partner_id = p_trading_partner_id,
958: pple1.vendor_site_id = decode(pple1.vendor_site_id,-1,-1,p_vendor_site_id)
959: WHERE pple1.trading_partner_id = p_dup_trading_partner_id
960: AND pple1.vendor_site_id = decode(pple1.vendor_site_id,-1,-1,p_dup_vendor_site_id)

Line 962: FROM pon_party_line_exclusions pple2

958: pple1.vendor_site_id = decode(pple1.vendor_site_id,-1,-1,p_vendor_site_id)
959: WHERE pple1.trading_partner_id = p_dup_trading_partner_id
960: AND pple1.vendor_site_id = decode(pple1.vendor_site_id,-1,-1,p_dup_vendor_site_id)
961: AND NOT EXISTS (SELECT 'DUPLICATE'
962: FROM pon_party_line_exclusions pple2
963: WHERE pple2.auction_header_id = pple1.auction_header_id
964: AND pple2.trading_partner_id = p_trading_partner_id
965: AND pple2.vendor_site_id =decode(pple2.vendor_site_id,-1,-1,p_vendor_site_id));
966:

Line 968: fnd_file.put_line (fnd_file.log, l_progress|| 'Done pon_party_line_exclusions');

964: AND pple2.trading_partner_id = p_trading_partner_id
965: AND pple2.vendor_site_id =decode(pple2.vendor_site_id,-1,-1,p_vendor_site_id));
966:
967: l_progress := 707;
968: fnd_file.put_line (fnd_file.log, l_progress|| 'Done pon_party_line_exclusions');
969:
970: UPDATE pon_pf_supplier_formula ppsf1
971: SET ppsf1.trading_partner_id = p_trading_partner_id,
972: ppsf1.vendor_site_id = decode(ppsf1.vendor_site_id,-1,-1,p_vendor_site_id),