APPS.PO_COMMUNICATION_PVT dependencies on PO_VENDOR_SITES_ALL

Line 939: l_supp_lang po_vendor_sites_all.language%TYPE;

935: l_document_subtype po_headers.type_lookup_code%TYPE;
936: l_document_type po_headers.type_lookup_code%TYPE;
937: l_territory fnd_languages.nls_territory%type;
938: l_language_code fnd_languages.language_code%type;
939: l_supp_lang po_vendor_sites_all.language%TYPE;
940: l_language fnd_languages.nls_language%type;
941: l_authorization_status po_headers.authorization_status%TYPE;
942: l_header_id po_headers.po_header_id%TYPE;
943:

Line 996: FROM po_vendor_sites_all pv,

992: l_header_id := l_document_id;
993:
994: SELECT pv.language
995: INTO l_supp_lang
996: FROM po_vendor_sites_all pv,
997: po_headers_all ph
998: WHERE ph.po_header_id = l_header_id
999: AND ph.vendor_site_id = pv.vendor_site_id;
1000:

Line 1705: FROM po_vendor_sites_all pv,po_headers_all ph

1701: WHERE po_release_id = l_document_id;
1702: END IF;
1703:
1704: SELECT pv.language into l_supp_lang
1705: FROM po_vendor_sites_all pv,po_headers_all ph
1706: WHERE
1707: ph.po_header_id = l_header_id and ph.vendor_site_id = pv.vendor_site_id;
1708:
1709:

Line 3379: Bug 3851357. Changed po_vendor_sites to po_vendor_sites_all because

3375: /* Bug 3849854. PDF is not communicated in Suppliers language
3376: According to the document_id (po_header_id/po_release_id),
3377: the language is found from po_vendor_sites and corresponding
3378: PDF is retrieved
3379: Bug 3851357. Changed po_vendor_sites to po_vendor_sites_all because
3380: po_vendor_sites is an org striped view. The query was failing in the
3381: particular case when the MO:Operating unit site level value was
3382: different from buyer's user level value */
3383: Begin

Line 3387: from po_vendor_sites_all pvs,po_headers_all ph,fnd_languages fl

3383: Begin
3384:
3385: if l_document_type in ('PO','PA') then
3386: select fl.language_code into l_language
3387: from po_vendor_sites_all pvs,po_headers_all ph,fnd_languages fl
3388: where ph.vendor_site_id = pvs.vendor_site_id
3389: and ph.po_header_id = l_document_id
3390: and pvs.language = fl.nls_language;
3391: elsif l_document_type = 'RELEASE' then

Line 3393: from po_vendor_sites_all pvs , po_headers_all ph,

3389: and ph.po_header_id = l_document_id
3390: and pvs.language = fl.nls_language;
3391: elsif l_document_type = 'RELEASE' then
3392: select fl.language_code into l_language
3393: from po_vendor_sites_all pvs , po_headers_all ph,
3394: po_releases_all pr, fnd_languages fl
3395: where ph.po_header_id = pr.po_header_id
3396: and pr.po_release_id = l_document_id
3397: and ph.vendor_site_id = pvs.vendor_site_id

Line 6264: --bug: 3463617 : Retreived address_line4 from po_vendor_sites_all.

6260: PO_COMMUNICATION_PVT.g_vendor_country :=null;
6261: PO_COMMUNICATION_PVT.g_vendor_city_state_zipInfo :=null;
6262: PO_COMMUNICATION_PVT.g_vendor_address_line_4 :=null; --bug: 3463617
6263:
6264: --bug: 3463617 : Retreived address_line4 from po_vendor_sites_all.
6265: SELECT PVS.ADDRESS_LINE1 ,
6266: PVS.ADDRESS_LINE2 ,
6267: PVS.ADDRESS_LINE3 ,
6268: PVS.CITY ,

Line 6277: PO_VENDOR_SITES_ALL PVS,

6273: INTO
6274: l_address_line_1, PO_COMMUNICATION_PVT.g_vendor_address_line_2, PO_COMMUNICATION_PVT.g_vendor_address_line_3,
6275: l_city, l_state, l_zip, PO_COMMUNICATION_PVT.g_vendor_country, PO_COMMUNICATION_PVT.g_vendor_address_line_4
6276: FROM
6277: PO_VENDOR_SITES_ALL PVS,
6278: FND_TERRITORIES_TL FTE
6279: WHERE
6280: PVS.COUNTRY = FTE.TERRITORY_CODE AND
6281: DECODE(FTE.TERRITORY_CODE, NULL, '1', FTE.LANGUAGE) = DECODE(FTE.TERRITORY_CODE, NULL, '1', USERENV('LANG')) AND