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.

[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on HZ_PARTIES

Line 885: l_supplier_address_line1 hz_parties.address1%type;

881:
882: l_bid_currency_code pon_bid_headers.bid_currency_code%type;
883: l_bid_price_precision pon_bid_headers.number_price_decimals%type;
884: -- bidpdf: address of supplier:
885: l_supplier_address_line1 hz_parties.address1%type;
886: l_supplier_address_line2 hz_parties.address2%type;
887: l_supplier_address_line3 hz_parties.address3%type;
888: l_supplier_address_city hz_parties.city%type;
889: l_supplier_address_state hz_parties.state%type;

Line 886: l_supplier_address_line2 hz_parties.address2%type;

882: l_bid_currency_code pon_bid_headers.bid_currency_code%type;
883: l_bid_price_precision pon_bid_headers.number_price_decimals%type;
884: -- bidpdf: address of supplier:
885: l_supplier_address_line1 hz_parties.address1%type;
886: l_supplier_address_line2 hz_parties.address2%type;
887: l_supplier_address_line3 hz_parties.address3%type;
888: l_supplier_address_city hz_parties.city%type;
889: l_supplier_address_state hz_parties.state%type;
890: l_supplier_postal_code hz_parties.postal_code%type;

Line 887: l_supplier_address_line3 hz_parties.address3%type;

883: l_bid_price_precision pon_bid_headers.number_price_decimals%type;
884: -- bidpdf: address of supplier:
885: l_supplier_address_line1 hz_parties.address1%type;
886: l_supplier_address_line2 hz_parties.address2%type;
887: l_supplier_address_line3 hz_parties.address3%type;
888: l_supplier_address_city hz_parties.city%type;
889: l_supplier_address_state hz_parties.state%type;
890: l_supplier_postal_code hz_parties.postal_code%type;
891: l_supplier_country_code hz_parties.country%type;

Line 888: l_supplier_address_city hz_parties.city%type;

884: -- bidpdf: address of supplier:
885: l_supplier_address_line1 hz_parties.address1%type;
886: l_supplier_address_line2 hz_parties.address2%type;
887: l_supplier_address_line3 hz_parties.address3%type;
888: l_supplier_address_city hz_parties.city%type;
889: l_supplier_address_state hz_parties.state%type;
890: l_supplier_postal_code hz_parties.postal_code%type;
891: l_supplier_country_code hz_parties.country%type;
892: l_supplier_country fnd_territories_tl.territory_short_name%type;

Line 889: l_supplier_address_state hz_parties.state%type;

885: l_supplier_address_line1 hz_parties.address1%type;
886: l_supplier_address_line2 hz_parties.address2%type;
887: l_supplier_address_line3 hz_parties.address3%type;
888: l_supplier_address_city hz_parties.city%type;
889: l_supplier_address_state hz_parties.state%type;
890: l_supplier_postal_code hz_parties.postal_code%type;
891: l_supplier_country_code hz_parties.country%type;
892: l_supplier_country fnd_territories_tl.territory_short_name%type;
893: l_vendor_site_id NUMBER;

Line 890: l_supplier_postal_code hz_parties.postal_code%type;

886: l_supplier_address_line2 hz_parties.address2%type;
887: l_supplier_address_line3 hz_parties.address3%type;
888: l_supplier_address_city hz_parties.city%type;
889: l_supplier_address_state hz_parties.state%type;
890: l_supplier_postal_code hz_parties.postal_code%type;
891: l_supplier_country_code hz_parties.country%type;
892: l_supplier_country fnd_territories_tl.territory_short_name%type;
893: l_vendor_site_id NUMBER;
894: l_vendor_id NUMBER;

Line 891: l_supplier_country_code hz_parties.country%type;

887: l_supplier_address_line3 hz_parties.address3%type;
888: l_supplier_address_city hz_parties.city%type;
889: l_supplier_address_state hz_parties.state%type;
890: l_supplier_postal_code hz_parties.postal_code%type;
891: l_supplier_country_code hz_parties.country%type;
892: l_supplier_country fnd_territories_tl.territory_short_name%type;
893: l_vendor_site_id NUMBER;
894: l_vendor_id NUMBER;
895: -- bidpdf: contact details:

Line 1059: 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)

1055:
1056: IF l_vendor_site_id <= 0 THEN
1057: BEGIN
1058: -- bidpdf: address/contact of supplier company
1059: 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)
1060: ,PON_LOCALE_PKG.get_party_display_name(pon_bid_headers.trading_partner_contact_id)
1061: 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
1062: ,l_contact_details_name
1063: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr

Line 1063: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr

1059: 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)
1060: ,PON_LOCALE_PKG.get_party_display_name(pon_bid_headers.trading_partner_contact_id)
1061: 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
1062: ,l_contact_details_name
1063: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr
1064: where pon_bid_headers.trading_partner_id = hz_parties.party_id
1065: and pon_bid_headers.bid_number = p_bid_number
1066: and entity_terr.territory_code(+) = hz_parties.country
1067: and entity_terr.territory_code(+) NOT IN ('ZR','FX','LX')

Line 1064: where pon_bid_headers.trading_partner_id = hz_parties.party_id

1060: ,PON_LOCALE_PKG.get_party_display_name(pon_bid_headers.trading_partner_contact_id)
1061: 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
1062: ,l_contact_details_name
1063: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr
1064: where pon_bid_headers.trading_partner_id = hz_parties.party_id
1065: and pon_bid_headers.bid_number = p_bid_number
1066: and entity_terr.territory_code(+) = hz_parties.country
1067: and entity_terr.territory_code(+) NOT IN ('ZR','FX','LX')
1068: and entity_terr.language(+) = l_printing_language

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

1062: ,l_contact_details_name
1063: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr
1064: where pon_bid_headers.trading_partner_id = hz_parties.party_id
1065: and pon_bid_headers.bid_number = p_bid_number
1066: and entity_terr.territory_code(+) = hz_parties.country
1067: and entity_terr.territory_code(+) NOT IN ('ZR','FX','LX')
1068: and entity_terr.language(+) = l_printing_language
1069: and rownum = 1;
1070: EXCEPTION

Line 3145: hz_parties hp1,

3141: hr_locations_all loc_ship,
3142: fnd_territories_tl ship_territories_tl,
3143: fnd_currencies_tl currency_tl ,
3144: pon_auc_doctypes doctypes,
3145: hz_parties hp1,
3146: hr_operating_units ou,
3147: hr_all_organization_units entity,
3148: hr_all_organization_units_tl entitytl,
3149: hr_locations_all entity_loc,