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_BIDDING_PARTIES

Line 525: 2. pon_bidding_parties

521:
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:

Line 573: UPDATE pon_bidding_parties pbp1

569: WHERE pv.vendor_id = p_dup_vendor_id
570: AND pv.vendor_id = pvs.vendor_id
571: AND pvs.vendor_site_id = p_dup_vendor_site_id;
572:
573: UPDATE pon_bidding_parties pbp1
574: set pbp1.vendor_site_id = decode(pbp1.vendor_site_id , -1,-1, p_vendor_site_id),
575: pbp1.vendor_site_code = decode(pbp1.vendor_site_code,'-1','-1',p_vendor_site_code)
576: WHERE pbp1.trading_partner_id = l_trading_partner_id
577: AND ((pbp1.vendor_site_id = p_dup_vendor_site_id and pbp1.list_id = -1)

Line 589: FROM pon_bidding_parties pbp2

585: and pah.global_template_flag='Y' )
586: )
587: )
588: AND NOT EXISTS (SELECT 'DUPLICATE'
589: FROM pon_bidding_parties pbp2
590: WHERE pbp2.auction_header_id = pbp1.auction_header_id
591: AND pbp2.list_id = pbp1.list_id
592: AND pbp2.trading_partner_id = pbp1.trading_partner_id
593: AND decode(pbp2.vendor_site_code,'-1',p_vendor_site_code,pbp2.vendor_site_code) = p_vendor_site_code

Line 597: fnd_file.put_line (fnd_file.log, l_progress|| 'Done : pon_bidding_parties');

593: AND decode(pbp2.vendor_site_code,'-1',p_vendor_site_code,pbp2.vendor_site_code) = p_vendor_site_code
594: AND decode(pbp2.vendor_site_id,-1, p_vendor_site_id,pbp2.vendor_site_id) = p_vendor_site_id);
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,

Line 675: 3. pon_bidding_parties

671:
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:

Line 739: UPDATE pon_bidding_parties pbp1

735: WHERE pv.vendor_id = p_dup_vendor_id
736: AND pv.vendor_id = pvs.vendor_id
737: AND pvs.vendor_site_id = p_dup_vendor_site_id;
738:
739: UPDATE pon_bidding_parties pbp1
740: SET pbp1.trading_partner_id = p_trading_partner_id,
741: pbp1.trading_partner_name = p_trading_partner_name,
742: pbp1.vendor_site_code = decode(pbp1.vendor_site_code,'-1','-1',p_vendor_site_code),
743: pbp1.vendor_site_id = decode(vendor_site_id , -1,-1, p_vendor_site_id),

Line 759: FROM pon_bidding_parties pbp2

755: and pah.global_template_flag='Y' )
756: )
757: )
758: AND NOT EXISTS (SELECT 'DUPLICATE'
759: FROM pon_bidding_parties pbp2
760: WHERE pbp2.auction_header_id = pbp1.auction_header_id
761: AND pbp2.list_id = pbp1.list_id
762: AND decode(pbp2.vendor_site_code,'-1',p_vendor_site_code,pbp2.vendor_site_code) = p_vendor_site_code
763: AND pbp2.trading_partner_id = p_trading_partner_id

Line 767: fnd_file.put_line (fnd_file.log, l_progress|| ' Done: pon_bidding_parties');

763: AND pbp2.trading_partner_id = p_trading_partner_id
764: AND decode(pbp2.vendor_site_id,-1, p_vendor_site_id,pbp2.vendor_site_id) = p_vendor_site_id);
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,

Line 849: 3. pon_bidding_parties

845: Followling table will be updated while merging last site
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

Line 926: UPDATE pon_bidding_parties pbp1

922: WHERE pv.vendor_id = p_dup_vendor_id
923: AND pv.vendor_id = pvs.vendor_id
924: AND pvs.vendor_site_id = p_dup_vendor_site_id;
925:
926: UPDATE pon_bidding_parties pbp1
927: SET pbp1.trading_partner_id = p_trading_partner_id,
928: pbp1.trading_partner_name = p_trading_partner_name,
929: pbp1.vendor_site_id = decode(pbp1.vendor_site_id,-1,-1,p_vendor_site_id),
930: pbp1.vendor_site_code = decode(pbp1.vendor_site_code,'-1','-1',p_vendor_site_code),

Line 946: FROM pon_bidding_parties pbp2

942: and pah.global_template_flag='Y' )
943: )
944: )
945: AND NOT EXISTS (SELECT 'DUPLICATE'
946: FROM pon_bidding_parties pbp2
947: WHERE pbp2.auction_header_id = pbp1.auction_header_id
948: AND pbp2.list_id = pbp1.list_id
949: AND pbp2.trading_partner_id = p_trading_partner_id
950: AND decode(pbp2.vendor_site_code,'-1',p_vendor_site_code,pbp2.vendor_site_code) = p_vendor_site_code

Line 954: fnd_file.put_line (fnd_file.log, l_progress|| 'Done pon_bidding_parties');

950: AND decode(pbp2.vendor_site_code,'-1',p_vendor_site_code,pbp2.vendor_site_code) = p_vendor_site_code
951: AND pbp2.vendor_site_id = decode(pbp1.vendor_site_id,-1,-1,p_vendor_site_id));
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)