[Home] [Help]
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:
896: l_contact_details_name varchar2(600);
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')
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'
1691: ,pbip.has_quantity_tiers bidline_has_quantity_tiers
1692: from
1693: pon_auction_item_prices_all paip ,
1694: hr_locations_all hl,
1695: fnd_territories_tl tl,
1696: per_jobs_vl jobs,
1697: icx_cat_categories_v icx,
1698: mtl_units_of_measure_tl units,
1699: po_line_types_tl lt
2404: hr_locations_all hrl,
2405: hr_all_organization_units hrorg,
2406: fnd_user fuser,
2407: po_lookup_codes lkp1,
2408: fnd_territories_tl terr,
2409: mtl_units_of_measure_tl uom_tl
2410: WHERE pay.auction_header_id = p_auction_header_id
2411: AND pay.project_id = proj.project_id(+)
2412: AND pay.project_task_id = task.task_id(+)
2480: hr_locations_all hrl,
2481: hr_all_organization_units hrorg,
2482: fnd_user fuser,
2483: po_lookup_codes lkp1,
2484: fnd_territories_tl terr,
2485: mtl_units_of_measure_tl uom_tl,
2486: pon_bid_payments_shipments pbp,
2487: pon_bid_item_prices pbip
2488: WHERE
2524: loc.region_1 county
2525: from
2526: hr_locations_all loc,
2527: pon_auction_shipments_all pas,
2528: fnd_territories_tl ship_territories_tl
2529: WHERE
2530: pas.auction_header_id = pah.auction_header_id
2531: and l_is_buyer_negpdf = 'N'
2532: and l_neg_has_price_breaks = 'Y'
2556: loc.region_1 county
2557: from
2558: hr_locations_all loc,
2559: hr_all_organization_units haou,
2560: fnd_territories_tl ship_territories_tl,
2561: mtl_parameters mp ,
2562: ( SELECT
2563: distinct pas.ship_to_organization_id
2564: FROM pon_auction_shipments_all pas
3136: fnd_lookup_values fl_freight_terms ,
3137: ap_terms ap ,
3138: fnd_lookup_values fl_fob ,
3139: hr_locations_all loc_bill,
3140: fnd_territories_tl bill_territories_tl,
3141: hr_locations_all loc_ship,
3142: fnd_territories_tl ship_territories_tl,
3143: fnd_currencies_tl currency_tl ,
3144: pon_auc_doctypes doctypes,
3138: fnd_lookup_values fl_fob ,
3139: hr_locations_all loc_bill,
3140: fnd_territories_tl bill_territories_tl,
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,
3146: hr_operating_units ou,
3147: hr_all_organization_units entity,
3148: hr_all_organization_units_tl entitytl,
3149: hr_locations_all entity_loc,
3150: fnd_territories_tl entity_terr,
3151: fnd_lookups fl_security,
3152: gl_daily_conversion_types gdct,
3153: fnd_product_groups fpg,
3154: pon_negotiation_styles_vl ns,