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_PRINTING_PKG dependencies on HZ_PARTIES

Line 1169: HZ_PARTIES hz

1165: pon_bidding_parties pbp,
1166: fnd_lookup_values fl,
1167: fnd_lookups fl1,
1168: pon_auc_doctypes doc,
1169: HZ_PARTIES hz
1170: where paha.auction_header_id = p_auction_header_id
1171: and pbp.auction_header_id = paha.auction_header_id
1172: and pbp.sequence = p_supplier_sequence
1173: and fl.lookup_type(+) = 'PON_AUCTION_EMD_TYPE'

Line 1417: HZ_PARTIES hz

1413: pon_bidding_parties pbp,
1414: fnd_lookup_values fl,
1415: fnd_lookups fl1,
1416: pon_auc_doctypes doc,
1417: HZ_PARTIES hz
1418: where paha.auction_header_id = p_auction_header_id
1419: and pbp.auction_header_id = paha.auction_header_id
1420: --Begin: Added by Chaoqun on 22-DEC-2008
1421: and pbp.sequence = petr.supplier_sequence

Line 1636: HZ_PARTIES hz

1632: fnd_lookup_values flv,
1633: HR_ALL_ORGANIZATION_UNITS_TL ou,
1634: pon_auc_doctypes doc,
1635: fnd_lookups f1,
1636: HZ_PARTIES hz
1637: where paha.auction_header_id = p_auction_header_id
1638: and petr.auction_header_id = paha.auction_header_id
1639: and petr.supplier_sequence = p_supplier_sequence
1640: and pbp.auction_header_id = paha.auction_header_id

Line 1820: l_supplier_address_line1 hz_parties.address1%type;

1816:
1817: l_bid_currency_code pon_bid_headers.bid_currency_code%type;
1818: l_bid_price_precision pon_bid_headers.number_price_decimals%type;
1819: -- bidpdf: address of supplier:
1820: l_supplier_address_line1 hz_parties.address1%type;
1821: l_supplier_address_line2 hz_parties.address2%type;
1822: l_supplier_address_line3 hz_parties.address3%type;
1823: l_supplier_address_city hz_parties.city%type;
1824: l_supplier_address_state hz_parties.state%type;

Line 1821: l_supplier_address_line2 hz_parties.address2%type;

1817: l_bid_currency_code pon_bid_headers.bid_currency_code%type;
1818: l_bid_price_precision pon_bid_headers.number_price_decimals%type;
1819: -- bidpdf: address of supplier:
1820: l_supplier_address_line1 hz_parties.address1%type;
1821: l_supplier_address_line2 hz_parties.address2%type;
1822: l_supplier_address_line3 hz_parties.address3%type;
1823: l_supplier_address_city hz_parties.city%type;
1824: l_supplier_address_state hz_parties.state%type;
1825: l_supplier_postal_code hz_parties.postal_code%type;

Line 1822: l_supplier_address_line3 hz_parties.address3%type;

1818: l_bid_price_precision pon_bid_headers.number_price_decimals%type;
1819: -- bidpdf: address of supplier:
1820: l_supplier_address_line1 hz_parties.address1%type;
1821: l_supplier_address_line2 hz_parties.address2%type;
1822: l_supplier_address_line3 hz_parties.address3%type;
1823: l_supplier_address_city hz_parties.city%type;
1824: l_supplier_address_state hz_parties.state%type;
1825: l_supplier_postal_code hz_parties.postal_code%type;
1826: l_supplier_country_code hz_parties.country%type;

Line 1823: l_supplier_address_city hz_parties.city%type;

1819: -- bidpdf: address of supplier:
1820: l_supplier_address_line1 hz_parties.address1%type;
1821: l_supplier_address_line2 hz_parties.address2%type;
1822: l_supplier_address_line3 hz_parties.address3%type;
1823: l_supplier_address_city hz_parties.city%type;
1824: l_supplier_address_state hz_parties.state%type;
1825: l_supplier_postal_code hz_parties.postal_code%type;
1826: l_supplier_country_code hz_parties.country%type;
1827: l_supplier_country fnd_territories_tl.territory_short_name%type;

Line 1824: l_supplier_address_state hz_parties.state%type;

1820: l_supplier_address_line1 hz_parties.address1%type;
1821: l_supplier_address_line2 hz_parties.address2%type;
1822: l_supplier_address_line3 hz_parties.address3%type;
1823: l_supplier_address_city hz_parties.city%type;
1824: l_supplier_address_state hz_parties.state%type;
1825: l_supplier_postal_code hz_parties.postal_code%type;
1826: l_supplier_country_code hz_parties.country%type;
1827: l_supplier_country fnd_territories_tl.territory_short_name%type;
1828: l_vendor_site_id NUMBER;

Line 1825: l_supplier_postal_code hz_parties.postal_code%type;

1821: l_supplier_address_line2 hz_parties.address2%type;
1822: l_supplier_address_line3 hz_parties.address3%type;
1823: l_supplier_address_city hz_parties.city%type;
1824: l_supplier_address_state hz_parties.state%type;
1825: l_supplier_postal_code hz_parties.postal_code%type;
1826: l_supplier_country_code hz_parties.country%type;
1827: l_supplier_country fnd_territories_tl.territory_short_name%type;
1828: l_vendor_site_id NUMBER;
1829: l_vendor_id NUMBER;

Line 1826: l_supplier_country_code hz_parties.country%type;

1822: l_supplier_address_line3 hz_parties.address3%type;
1823: l_supplier_address_city hz_parties.city%type;
1824: l_supplier_address_state hz_parties.state%type;
1825: l_supplier_postal_code hz_parties.postal_code%type;
1826: l_supplier_country_code hz_parties.country%type;
1827: l_supplier_country fnd_territories_tl.territory_short_name%type;
1828: l_vendor_site_id NUMBER;
1829: l_vendor_id NUMBER;
1830: -- bidpdf: contact details:

Line 2006: select hz_parties.address1, hz_parties.address2, hz_parties.address3, hz_parties.city, hz_parties.state, hz_parties.postal_code, hz_parties.country, nvl(entity_terr.territory_short_name,hz_parties.country)

2002:
2003: IF l_vendor_site_id <= 0 THEN
2004: BEGIN
2005: -- bidpdf: address/contact of supplier company
2006: select hz_parties.address1, hz_parties.address2, hz_parties.address3, hz_parties.city, hz_parties.state, hz_parties.postal_code, hz_parties.country, nvl(entity_terr.territory_short_name,hz_parties.country)
2007: ,PON_LOCALE_PKG.get_party_display_name(pon_bid_headers.trading_partner_contact_id)
2008: 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
2009: ,l_contact_details_name
2010: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr

Line 2010: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr

2006: select hz_parties.address1, hz_parties.address2, hz_parties.address3, hz_parties.city, hz_parties.state, hz_parties.postal_code, hz_parties.country, nvl(entity_terr.territory_short_name,hz_parties.country)
2007: ,PON_LOCALE_PKG.get_party_display_name(pon_bid_headers.trading_partner_contact_id)
2008: 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
2009: ,l_contact_details_name
2010: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr
2011: where pon_bid_headers.trading_partner_id = hz_parties.party_id
2012: and pon_bid_headers.bid_number = p_bid_number
2013: and entity_terr.territory_code(+) = hz_parties.country
2014: and entity_terr.territory_code(+) NOT IN ('ZR','FX','LX')

Line 2011: where pon_bid_headers.trading_partner_id = hz_parties.party_id

2007: ,PON_LOCALE_PKG.get_party_display_name(pon_bid_headers.trading_partner_contact_id)
2008: 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
2009: ,l_contact_details_name
2010: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr
2011: where pon_bid_headers.trading_partner_id = hz_parties.party_id
2012: and pon_bid_headers.bid_number = p_bid_number
2013: and entity_terr.territory_code(+) = hz_parties.country
2014: and entity_terr.territory_code(+) NOT IN ('ZR','FX','LX')
2015: and entity_terr.language(+) = l_printing_language

Line 2013: and entity_terr.territory_code(+) = hz_parties.country

2009: ,l_contact_details_name
2010: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr
2011: where pon_bid_headers.trading_partner_id = hz_parties.party_id
2012: and pon_bid_headers.bid_number = p_bid_number
2013: and entity_terr.territory_code(+) = hz_parties.country
2014: and entity_terr.territory_code(+) NOT IN ('ZR','FX','LX')
2015: and entity_terr.language(+) = l_printing_language
2016: and rownum = 1;
2017: EXCEPTION

Line 2566: hz_parties hp1,

2562: hr_locations_all loc_ship,
2563: fnd_territories_tl ship_territories_tl,
2564: fnd_currencies_tl currency_tl ,
2565: pon_auc_doctypes doctypes,
2566: hz_parties hp1,
2567: hr_operating_units ou,
2568: hr_all_organization_units entity,
2569: hr_all_organization_units_tl entitytl,
2570: hr_locations_all entity_loc,