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_AUCTION_HEADERS_ALL

Line 583: and exists( select 1 from pon_auction_headers_all pah

579: (pbp1.vendor_site_code = l_dup_vendor_site_code and pbp1.list_id <> -1)
580: OR
581: ( pbp1.vendor_site_code = l_dup_vendor_site_code
582: and pbp1.auction_header_id is not null
583: and exists( select 1 from pon_auction_headers_all pah
584: where pah.auction_header_id = pbp1.auction_header_id
585: and pah.global_template_flag='Y' )
586: )
587: )

Line 753: and exists( select 1 from pon_auction_headers_all pah

749: (pbp1.vendor_site_code = l_dup_vendor_site_code and pbp1.list_id <> -1)
750: OR
751: ( pbp1.vendor_site_code = l_dup_vendor_site_code
752: and pbp1.auction_header_id is not null
753: and exists( select 1 from pon_auction_headers_all pah
754: where pah.auction_header_id = pbp1.auction_header_id
755: and pah.global_template_flag='Y' )
756: )
757: )

Line 940: and exists( select 1 from pon_auction_headers_all pah

936: (pbp1.vendor_site_code = decode(pbp1.vendor_site_code,'-1','-1',l_dup_vendor_site_code) and pbp1.list_id <> -1)
937: OR
938: ( pbp1.vendor_site_code = decode(pbp1.vendor_site_code,'-1','-1',l_dup_vendor_site_code)
939: and pbp1.auction_header_id is not null
940: and exists( select 1 from pon_auction_headers_all pah
941: where pah.auction_header_id = pbp1.auction_header_id
942: and pah.global_template_flag='Y' )
943: )
944: )

Line 1127: FROM pon_auction_headers_all ah,

1123: bh.created_by,
1124: SYSDATE,
1125: bh.last_updated_by,
1126: 0
1127: FROM pon_auction_headers_all ah,
1128: pon_bid_headers bh
1129: WHERE bh.trading_partner_id = p_dup_trading_partner_id
1130: AND ah.auction_header_id = bh.auction_header_id
1131: AND NOT EXISTS (

Line 1142: pon_auction_headers_all ah2

1138: AND NOT EXISTS
1139: (
1140: SELECT NULL
1141: FROM pon_bid_headers bh2,
1142: pon_auction_headers_all ah2
1143: WHERE ah2.auction_header_id = bh2.auction_header_id
1144: AND ah.auction_header_id_orig_amend = ah2.auction_header_id_orig_amend
1145: AND bh2.bid_number > bh.bid_number
1146: AND bh2.trading_partner_contact_id = bh.trading_partner_contact_id