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 FND_TERRITORIES_TL

Line 1827: l_supplier_country fnd_territories_tl.territory_short_name%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:
1831: l_contact_details_name varchar2(600);

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 2027: FROM PO_VENDOR_SITES_ALL pvsa, pon_auction_headers_all pah, pon_bidding_parties pbp, fnd_territories_tl entity_terr

2023: -- get supplier site address/contact, reference from java/poplist/server/VendorSitesAllVO.xml
2024: 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),
2025: 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
2026: 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
2027: FROM PO_VENDOR_SITES_ALL pvsa, pon_auction_headers_all pah, pon_bidding_parties pbp, fnd_territories_tl entity_terr
2028: WHERE
2029: pah.auction_header_id = p_auction_header_id
2030: AND pvsa.org_id = pah.org_id
2031: AND PURCHASING_SITE_FLAG = 'Y'

Line 2561: fnd_territories_tl bill_territories_tl,

2557: fnd_lookup_values flv,
2558: ap_terms ap ,
2559: fnd_lookup_values fl_fob ,
2560: hr_locations_all loc_bill,
2561: fnd_territories_tl bill_territories_tl,
2562: hr_locations_all loc_ship,
2563: fnd_territories_tl ship_territories_tl,
2564: fnd_currencies_tl currency_tl ,
2565: pon_auc_doctypes doctypes,

Line 2563: fnd_territories_tl ship_territories_tl,

2559: fnd_lookup_values fl_fob ,
2560: hr_locations_all loc_bill,
2561: fnd_territories_tl bill_territories_tl,
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,

Line 2571: fnd_territories_tl entity_terr,

2567: hr_operating_units ou,
2568: hr_all_organization_units entity,
2569: hr_all_organization_units_tl entitytl,
2570: hr_locations_all entity_loc,
2571: fnd_territories_tl entity_terr,
2572: fnd_lookups fl_security,
2573: gl_daily_conversion_types gdct,
2574: fnd_product_groups fpg,
2575: pon_negotiation_styles_vl ns,

Line 2840: fnd_territories_tl tl,

2836: ,pbip.has_quantity_tiers bidline_has_quantity_tiers
2837: from
2838: pon_auction_item_prices_all paip ,
2839: hr_locations_all hl,
2840: fnd_territories_tl tl,
2841: per_jobs_vl jobs,
2842: icx_cat_categories_v icx,
2843: mtl_units_of_measure_tl units,
2844: po_line_types_tl lt

Line 2967: fnd_territories_tl terr,

2963: hr_locations_all hrl,
2964: hr_all_organization_units hrorg,
2965: fnd_user fuser,
2966: po_lookup_codes lkp1,
2967: fnd_territories_tl terr,
2968: mtl_units_of_measure_tl uom_tl
2969: WHERE pay.auction_header_id = p_auction_header_id
2970: AND pay.line_number = line_num
2971: AND pay.project_id = proj.project_id(+)

Line 3042: fnd_territories_tl terr,

3038: hr_locations_all hrl,
3039: hr_all_organization_units hrorg,
3040: fnd_user fuser,
3041: po_lookup_codes lkp1,
3042: fnd_territories_tl terr,
3043: mtl_units_of_measure_tl uom_tl,
3044: pon_bid_payments_shipments pbp,
3045: pon_bid_item_prices pbip
3046: WHERE

Line 4114: fnd_territories_tl ship_territories_tl

4110: loc.region_1 county
4111: from
4112: hr_locations_all loc,
4113: pon_auction_shipments_all pas,
4114: fnd_territories_tl ship_territories_tl
4115: WHERE
4116: pas.auction_header_id = p_auction_header_id
4117: and l_is_buyer_negpdf = 'N'
4118: and l_neg_has_price_breaks = 'Y'

Line 4146: fnd_territories_tl ship_territories_tl,

4142: loc.region_1 county
4143: from
4144: hr_locations_all loc,
4145: hr_all_organization_units haou,
4146: fnd_territories_tl ship_territories_tl,
4147: mtl_parameters mp ,
4148: ( SELECT
4149: distinct pas.ship_to_organization_id
4150: FROM pon_auction_shipments_all pas