DBA Data[Home] [Help]

APPS.PO_COMMUNICATION_PVT dependencies on PO_VENDOR_SITES_ALL

Line 1084: l_supp_lang po_vendor_sites_all.language%TYPE;

1080: l_document_subtype po_headers.type_lookup_code%TYPE;
1081: l_document_type po_headers.type_lookup_code%TYPE;
1082: l_territory fnd_languages.nls_territory%type;
1083: l_language_code fnd_languages.language_code%type;
1084: l_supp_lang po_vendor_sites_all.language%TYPE;
1085: l_language fnd_languages.nls_language%type;
1086: l_authorization_status po_headers.authorization_status%TYPE;
1087: l_header_id po_headers.po_header_id%TYPE;
1088:

Line 1161: FROM po_vendor_sites_all pv,

1157: BEGIN
1158:
1159: SELECT pv.language
1160: INTO l_supp_lang
1161: FROM po_vendor_sites_all pv,
1162: po_headers_all ph
1163: WHERE ph.po_header_id = l_header_id
1164: AND ph.vendor_site_id = pv.vendor_site_id;
1165:

Line 1993: FROM po_vendor_sites_all pv, po_headers_all ph

1989: END IF;
1990:
1991: BEGIN
1992: SELECT pv.language into l_supp_lang
1993: FROM po_vendor_sites_all pv, po_headers_all ph
1994: WHERE
1995: ph.po_header_id = l_header_id and ph.vendor_site_id = pv.vendor_site_id;
1996: EXCEPTION
1997: WHEN NO_DATA_FOUND THEN

Line 3860: Bug 3851357. Changed po_vendor_sites to po_vendor_sites_all because

3856: /* Bug 3849854. PDF is not communicated in Suppliers language
3857: According to the document_id (po_header_id/po_release_id),
3858: the language is found from po_vendor_sites and corresponding
3859: PDF is retrieved
3860: Bug 3851357. Changed po_vendor_sites to po_vendor_sites_all because
3861: po_vendor_sites is an org striped view. The query was failing in the
3862: particular case when the MO:Operating unit site level value was
3863: different from buyer's user level value */
3864: Begin

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

3864: Begin
3865:
3866: if l_document_type in ('PO', 'PA') then
3867: select fl.language_code into l_language
3868: from po_vendor_sites_all pvs, po_headers_all ph, fnd_languages fl
3869: where ph.vendor_site_id = pvs.vendor_site_id
3870: and ph.po_header_id = l_document_id
3871: and pvs.language = fl.nls_language;
3872: elsif l_document_type = 'RELEASE' then

Line 3874: from po_vendor_sites_all pvs , po_headers_all ph,

3870: and ph.po_header_id = l_document_id
3871: and pvs.language = fl.nls_language;
3872: elsif l_document_type = 'RELEASE' then
3873: select fl.language_code into l_language
3874: from po_vendor_sites_all pvs , po_headers_all ph,
3875: po_releases_all pr, fnd_languages fl
3876: where ph.po_header_id = pr.po_header_id
3877: and pr.po_release_id = l_document_id
3878: and ph.vendor_site_id = pvs.vendor_site_id

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

7370: PO_COMMUNICATION_PVT.g_vendor_country := null;
7371: PO_COMMUNICATION_PVT.g_vendor_city_state_zipInfo := null;
7372: PO_COMMUNICATION_PVT.g_vendor_address_line_4 := null; --bug: 3463617
7373:
7374: --bug: 3463617 : Retreived address_line4 from po_vendor_sites_all.
7375: SELECT PVS.ADDRESS_LINE1 ,
7376: PVS.ADDRESS_LINE2 ,
7377: PVS.ADDRESS_LINE3 ,
7378: PVS.CITY ,

Line 7387: PO_VENDOR_SITES_ALL PVS,

7383: INTO
7384: l_address_line_1, PO_COMMUNICATION_PVT.g_vendor_address_line_2, PO_COMMUNICATION_PVT.g_vendor_address_line_3,
7385: l_city, l_state, l_zip, PO_COMMUNICATION_PVT.g_vendor_country, PO_COMMUNICATION_PVT.g_vendor_address_line_4
7386: FROM
7387: PO_VENDOR_SITES_ALL PVS,
7388: FND_TERRITORIES_TL FTE
7389: WHERE
7390: PVS.COUNTRY = FTE.TERRITORY_CODE AND
7391: DECODE(FTE.TERRITORY_CODE, NULL, '1', FTE.LANGUAGE) = DECODE(FTE.TERRITORY_CODE, NULL, '1', USERENV('LANG')) AND