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.PO_COMMUNICATION_PVT dependencies on PO_VENDOR_SITES

Line 67: g_vendor_address_line_2 PO_VENDOR_SITES.ADDRESS_LINE2%type := null;

63: g_arcAgent_id PO_HEADERS_ARCHIVE_ALL.AGENT_ID%type :=null;
64: g_header_id1 PO_HEADERS_ALL.PO_HEADER_ID%type := null;
65: g_release_id PO_RELEASES_ALL.PO_RELEASE_ID%type :=null;
66: g_timezone VARCHAR2(255) :=NULL;
67: g_vendor_address_line_2 PO_VENDOR_SITES.ADDRESS_LINE2%type := null;
68: g_vendor_address_line_3 PO_VENDOR_SITES.ADDRESS_LINE3%type := null;
69: g_vendor_country FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%type :=null;
70: g_vendor_city_state_zipInfo varchar2(500) :=null;
71: g_vendor_site_id PO_HEADERS_ALL.vendor_site_id%type :=null;

Line 68: g_vendor_address_line_3 PO_VENDOR_SITES.ADDRESS_LINE3%type := null;

64: g_header_id1 PO_HEADERS_ALL.PO_HEADER_ID%type := null;
65: g_release_id PO_RELEASES_ALL.PO_RELEASE_ID%type :=null;
66: g_timezone VARCHAR2(255) :=NULL;
67: g_vendor_address_line_2 PO_VENDOR_SITES.ADDRESS_LINE2%type := null;
68: g_vendor_address_line_3 PO_VENDOR_SITES.ADDRESS_LINE3%type := null;
69: g_vendor_country FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%type :=null;
70: g_vendor_city_state_zipInfo varchar2(500) :=null;
71: g_vendor_site_id PO_HEADERS_ALL.vendor_site_id%type :=null;
72: g_job_id PO_LINES_ALL.JOB_ID%type :=null;

Line 613: l_vendor_site_lang PO_VENDOR_SITES.LANGUAGE%TYPE;

609: l_itemtype po_document_types.wf_approval_itemtype%type;
610: l_workflow_process po_document_types.wf_approval_process%type;
611: l_vendor_site_code varchar2(15);
612: l_vendor_site_id number;
613: l_vendor_site_lang PO_VENDOR_SITES.LANGUAGE%TYPE;
614: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
615: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
616: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;
617: l_po_email_performer WF_USERS.NAME%TYPE;

Line 793: from po_headers poh, po_vendor_sites pvs, po_releases por

789:
790: if p_document_type = 'RELEASE' then
791: select poh.vendor_site_id, pvs.vendor_site_code, pvs.language
792: into l_vendor_site_id, l_vendor_site_code, l_vendor_site_lang
793: from po_headers poh, po_vendor_sites pvs, po_releases por
794: where pvs.vendor_site_id = poh.vendor_site_id
795: and poh.po_header_id = por.po_header_id
796: and por.po_release_id = p_document_id;
797: else

Line 800: from po_headers poh, po_vendor_sites pvs

796: and por.po_release_id = p_document_id;
797: else
798: select poh.vendor_site_id, pvs.vendor_site_code, pvs.language
799: into l_vendor_site_id, l_vendor_site_code, l_vendor_site_lang
800: from po_headers poh, po_vendor_sites pvs
801: where pvs.vendor_site_id = poh.vendor_site_id
802: and poh.po_header_id = p_document_id;
803: end if;
804:

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 2322: select pvs.language into l_supp_lang from po_vendor_sites pvs , po_headers_all ph

2318: l_progress := '010';
2319: begin
2320: if p_document_type in ('STANDARD','BLANKET','CONTRACT') then
2321: l_entity_name := 'PO_HEAD';
2322: select pvs.language into l_supp_lang from po_vendor_sites pvs , po_headers_all ph
2323: where po_header_id = p_document_id and ph.vendor_site_id = pvs.vendor_site_id ;
2324: else
2325: l_entity_name := 'PO_REL';
2326: select pvs.language into l_supp_lang from po_vendor_sites pvs , po_headers_all ph,po_releases_all pr

Line 2326: select pvs.language into l_supp_lang from po_vendor_sites pvs , po_headers_all ph,po_releases_all pr

2322: select pvs.language into l_supp_lang from po_vendor_sites pvs , po_headers_all ph
2323: where po_header_id = p_document_id and ph.vendor_site_id = pvs.vendor_site_id ;
2324: else
2325: l_entity_name := 'PO_REL';
2326: select pvs.language into l_supp_lang from po_vendor_sites pvs , po_headers_all ph,po_releases_all pr
2327: where ph.po_header_id = pr.po_header_id and pr.po_release_id = p_document_id and
2328: ph.vendor_site_id = pvs.vendor_site_id ;
2329: end if;
2330: IF g_debug_stmt THEN

Line 2722: select pvs.language into l_supp_lang from po_vendor_sites pvs , po_headers_all ph

2718: end if;
2719:
2720: l_progress := '200';
2721: if p_document_type in ('STANDARD','BLANKET','CONTRACT') then
2722: select pvs.language into l_supp_lang from po_vendor_sites pvs , po_headers_all ph
2723: where po_header_id = p_document_id and ph.vendor_site_id = pvs.vendor_site_id ;
2724: else
2725: select pvs.language into l_supp_lang from po_vendor_sites pvs , po_headers_all ph,po_releases_all pr
2726: where ph.po_header_id = pr.po_header_id and pr.po_release_id = p_document_id and

Line 2725: select pvs.language into l_supp_lang from po_vendor_sites pvs , po_headers_all ph,po_releases_all pr

2721: if p_document_type in ('STANDARD','BLANKET','CONTRACT') then
2722: select pvs.language into l_supp_lang from po_vendor_sites pvs , po_headers_all ph
2723: where po_header_id = p_document_id and ph.vendor_site_id = pvs.vendor_site_id ;
2724: else
2725: select pvs.language into l_supp_lang from po_vendor_sites pvs , po_headers_all ph,po_releases_all pr
2726: where ph.po_header_id = pr.po_header_id and pr.po_release_id = p_document_id and
2727: ph.vendor_site_id = pvs.vendor_site_id ;
2728: end if;
2729:

Line 3377: the language is found from po_vendor_sites and corresponding

3373: l_filename := po_communication_pvt.getPDFFileName(l_document_type,'_TERMS_',l_org_id,l_document_id,l_revision_number,l_language);
3374: else
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

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 3380: po_vendor_sites is an org striped view. The query was failing in the

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
3384:

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 4496: (entity_name = ''PO_VENDOR_SITES'' AND

4492: (entity_name = ''PO_RELEASES'' AND
4493: pk1_value = to_char(phx.po_release_id)) OR
4494: (entity_name = ''PO_VENDORS'' AND
4495: pk1_value = to_char(phx.vendor_id)) OR
4496: (entity_name = ''PO_VENDOR_SITES'' AND
4497: pk1_value = to_char(phx.vendor_site_id))) AND -- bug6154354
4498: function_name = ''PO_PRINTPO''
4499: AND fad.media_id = fds.media_id
4500: AND fad.datatype_id=1

Line 4509: (fad.entity_name=''PO_VENDOR_SITES'' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354

4505: FROM fnd_attached_docs_form_vl fad
4506: WHERE ((fad.entity_name=''PO_HEADERS'' AND fad.pk1_value=to_char(phx.po_header_id)) OR
4507: (fad.entity_name=''PO_RELEASES'' AND fad.pk1_value=to_char(phx.po_release_id)) OR
4508: (fad.entity_name=''PO_VENDORS'' AND fad.pk1_value=to_char(phx.vendor_id)) OR
4509: (fad.entity_name=''PO_VENDOR_SITES'' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354
4510: )
4511: AND fad.datatype_id=5
4512: AND fad.function_name=''PO_PRINTPO''
4513: order by fad.entity_name,fad.seq_num) AS header_url_attachments'; --bug6133951

Line 4521: (fad.entity_name=''PO_VENDOR_SITES'' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354

4517: FROM fnd_attached_docs_form_vl fad
4518: WHERE ((fad.entity_name=''PO_HEADERS'' AND fad.pk1_value=to_char(phx.po_header_id)) OR
4519: (fad.entity_name=''PO_RELEASES'' AND fad.pk1_value=to_char(phx.po_release_id)) OR
4520: (fad.entity_name=''PO_VENDORS'' AND fad.pk1_value=to_char(phx.vendor_id)) OR
4521: (fad.entity_name=''PO_VENDOR_SITES'' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354
4522: )
4523: AND fad.datatype_id=6
4524: AND fad.function_name=''PO_PRINTPO''
4525: order by fad.entity_name,fad.seq_num) AS header_file_attachments'; --bug6133951

Line 4541: (entity_name = ''PO_VENDOR_SITES'' AND

4537: WHERE ((entity_name = ''PO_HEADERS'' AND
4538: pk1_value = to_char(phx.po_header_id)) OR
4539: (entity_name = ''PO_VENDORS'' AND
4540: pk1_value = to_char(phx.vendor_id)) OR
4541: (entity_name = ''PO_VENDOR_SITES'' AND
4542: pk1_value = to_char(phx.vendor_site_id))) AND -- bug6154354
4543: function_name = ''PO_PRINTPO''
4544: AND fad.media_id = fds.media_id
4545: AND fad.datatype_id=1 order by fad.seq_num) AS header_short_text'; --bug6133951

Line 4553: (fad.entity_name=''PO_VENDOR_SITES'' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354

4549: SELECT fad.url web_page --Bug#4958642
4550: FROM fnd_attached_docs_form_vl fad
4551: WHERE ((fad.entity_name=''PO_HEADERS'' AND fad.pk1_value=to_char(phx.po_header_id)) OR
4552: (fad.entity_name=''PO_VENDORS'' AND fad.pk1_value=to_char(phx.vendor_id)) OR
4553: (fad.entity_name=''PO_VENDOR_SITES'' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354
4554: )
4555: AND fad.datatype_id=5
4556: AND fad.function_name=''PO_PRINTPO''
4557: order by fad.entity_name,fad.seq_num) AS header_url_attachments'; --bug6133951

Line 4564: (fad.entity_name=''PO_VENDOR_SITES'' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354

4560: SELECT fad.file_name
4561: FROM fnd_attached_docs_form_vl fad
4562: WHERE ((fad.entity_name=''PO_HEADERS'' AND fad.pk1_value=to_char(phx.po_header_id)) OR
4563: (fad.entity_name=''PO_VENDORS'' AND fad.pk1_value=to_char(phx.vendor_id)) OR
4564: (fad.entity_name=''PO_VENDOR_SITES'' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354
4565: )
4566: AND fad.datatype_id=6
4567: AND fad.function_name=''PO_PRINTPO''
4568: order by fad.entity_name,fad.seq_num) AS header_file_attachments'; --bug6133951

Line 6248: l_city PO_VENDOR_SITES.city%type := null;

6244: end;
6245:
6246: function getVendorAddressLine1(p_vendor_site_id in NUMBER) return VARCHAR2 is
6247:
6248: l_city PO_VENDOR_SITES.city%type := null;
6249: l_state PO_VENDOR_SITES.state%type := null;
6250: l_zip PO_VENDOR_SITES.zip%type := null;
6251: l_address_line_1 PO_VENDOR_SITES.ADDRESS_LINE1%type := null;
6252:

Line 6249: l_state PO_VENDOR_SITES.state%type := null;

6245:
6246: function getVendorAddressLine1(p_vendor_site_id in NUMBER) return VARCHAR2 is
6247:
6248: l_city PO_VENDOR_SITES.city%type := null;
6249: l_state PO_VENDOR_SITES.state%type := null;
6250: l_zip PO_VENDOR_SITES.zip%type := null;
6251: l_address_line_1 PO_VENDOR_SITES.ADDRESS_LINE1%type := null;
6252:
6253: begin

Line 6250: l_zip PO_VENDOR_SITES.zip%type := null;

6246: function getVendorAddressLine1(p_vendor_site_id in NUMBER) return VARCHAR2 is
6247:
6248: l_city PO_VENDOR_SITES.city%type := null;
6249: l_state PO_VENDOR_SITES.state%type := null;
6250: l_zip PO_VENDOR_SITES.zip%type := null;
6251: l_address_line_1 PO_VENDOR_SITES.ADDRESS_LINE1%type := null;
6252:
6253: begin
6254:

Line 6251: l_address_line_1 PO_VENDOR_SITES.ADDRESS_LINE1%type := null;

6247:
6248: l_city PO_VENDOR_SITES.city%type := null;
6249: l_state PO_VENDOR_SITES.state%type := null;
6250: l_zip PO_VENDOR_SITES.zip%type := null;
6251: l_address_line_1 PO_VENDOR_SITES.ADDRESS_LINE1%type := null;
6252:
6253: begin
6254:
6255: if PO_COMMUNICATION_PVT.g_vendor_site_id <> p_vendor_site_id or

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