APPS.PON_PRINTING_PKG dependencies on PON_BIDDING_PARTIES

Line 1080: FROM PO_VENDOR_SITES_ALL pvsa, pon_auction_headers_all pah, pon_bidding_parties pbp, fnd_territories_tl entity_terr

1076: -- get supplier site address/contact, reference from java/poplist/server/VendorSitesAllVO.xml
1077: SELECT pvsa.address_line1,pvsa.address_line2,pvsa.address_line3,pvsa.city,pvsa.state,pvsa.zip,pvsa.country, nvl(entity_terr.territory_short_name,pvsa.country),
1078: decode(pbp.trading_partner_contact_id, null, pbp.requested_supp_contact_name, PON_LOCALE_PKG.get_party_display_name(pbp.trading_partner_contact_id)) contact_name
1079: into l_supplier_address_line1,l_supplier_address_line2,l_supplier_address_line3,l_supplier_address_city,l_supplier_address_state,l_supplier_postal_code,l_supplier_country_code,l_supplier_country,l_contact_details_name
1080: FROM PO_VENDOR_SITES_ALL pvsa, pon_auction_headers_all pah, pon_bidding_parties pbp, fnd_territories_tl entity_terr
1081: WHERE
1082: pah.auction_header_id = p_auction_header_id
1083: AND pvsa.org_id = pah.org_id
1084: AND PURCHASING_SITE_FLAG = 'Y'

Line 1128: FROM pon_bidding_parties

1124: OR p_requested_supplier_id IS NOT NULL) THEN
1125: BEGIN
1126: SELECT sequence
1127: INTO l_supplier_sequence_number
1128: FROM pon_bidding_parties
1129: WHERE
1130: auction_header_id = p_auction_header_id
1131: AND ((trading_partner_id = l_trading_partner_id AND
1132: vendor_site_id = p_vendor_site_id) OR

Line 1728: from pon_bidding_parties bp

1724: = nvl(hr_general.get_business_group_id, nvl(hl.business_group_id(+), -99))
1725: and (l_is_buyer_negpdf = 'Y'
1726: or
1727: (not exists (select 'x'
1728: from pon_bidding_parties bp
1729: where bp.auction_header_id = paip.auction_header_id
1730: and ((bp.trading_partner_id = l_trading_partner_id
1731: and bp.vendor_site_id = p_vendor_site_id)
1732: OR bp.requested_supplier_id = p_requested_supplier_id)

Line 1873: pon_bidding_parties pbp,

1869: ftl.name bid_currency_name,
1870: pbp.number_price_decimals,
1871: nvl2(pbp.rate_dsp, pon_printing_pkg.format_number(pbp.rate_dsp), null) as display_rate
1872: FROM
1873: pon_bidding_parties pbp,
1874: fnd_currencies_tl ftl
1875: WHERE
1876: pbp.auction_header_id = pah.auction_header_id
1877: AND (l_is_buyer_negpdf = 'N')

Line 1986: FROM pon_bidding_parties pbp

1982: pbp.auction_header_id,
1983: pbp.trading_partner_id,
1984: pbp.trading_partner_contact_id,
1985: pbp.sequence
1986: FROM pon_bidding_parties pbp
1987: WHERE
1988: pbp.auction_header_id = pah.auction_header_id
1989: AND l_is_buyer_negpdf = 'Y'
1990: ORDER BY sequence asc) AS INVITED_SUPPLIERS,