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_EMAIL_GENERATE dependencies on PO_RELEASES

Line 160: -- po_releases.note_to_vendor:

156: l_attachments_text varchar2(32000) := '';
157:
158: /** Fix for PO UTF8 Project **/
159: -- This holds data from either po_headers.note_to_vendor or
160: -- po_releases.note_to_vendor:
161: l_header_note_to_vendor po_headers_all.note_to_vendor%TYPE;
162: -- l_header_note_to_vendor varchar2(240);
163:
164: x_pb_count number;

Line 498: /* Bug 2791859 po_releases_all should be used instead of po_releases */

494: from po_headers_all
495: where po_header_id = l_document_id;
496:
497: elsif (l_document_type = 'RELEASE') then
498: /* Bug 2791859 po_releases_all should be used instead of po_releases */
499: select po_header_id into l_po_header_id from po_releases_all
500: where po_release_id = l_document_id;
501:
502: select authorization_status

Line 499: select po_header_id into l_po_header_id from po_releases_all

495: where po_header_id = l_document_id;
496:
497: elsif (l_document_type = 'RELEASE') then
498: /* Bug 2791859 po_releases_all should be used instead of po_releases */
499: select po_header_id into l_po_header_id from po_releases_all
500: where po_release_id = l_document_id;
501:
502: select authorization_status
503: into l_document_status

Line 672: from po_releases

668:
669:
670: select note_to_vendor ,po_header_id
671: into l_header_note_to_vendor , l_po_header_id
672: from po_releases
673: where po_release_id = to_number(l_document_id);
674:
675: select currency_code into l_currency_code
676: from po_headers

Line 723: open attachments_cursor('PO_RELEASES', l_document_id);

719: -- Getting the header level text information and displaying it if it exists
720: if (l_document_type in ('PO', 'PA')) then
721: open attachments_cursor('PO_HEADERS', l_document_id);
722: elsif (l_document_type = 'RELEASE') then
723: open attachments_cursor('PO_RELEASES', l_document_id);
724: else
725: null;
726: end if;
727: loop

Line 781: select po_header_id into l_po_header_id from po_releases

777: --
778: -- Getting the header level text information and displaying it if it exists
779: -- for the blanket to which this release is sourced
780: if (l_document_type = 'RELEASE') THEN
781: select po_header_id into l_po_header_id from po_releases
782: where po_release_id = l_document_id;
783:
784: open attachments_cursor('PO_HEADERS', l_po_header_id);
785:

Line 1977: from po_releases where po_release_id = to_number(l_document_id);

1973: open shipment_cursor(l_document_id);
1974: ELSIF (l_document_type = 'RELEASE') THEN
1975: select note_to_vendor
1976: into l_header_note_to_vendor
1977: from po_releases where po_release_id = to_number(l_document_id);
1978: open shipment_release_cursor(l_document_id);
1979: ELSIF (l_document_type = 'PA') THEN
1980: select note_to_vendor,currency_code
1981: into l_header_note_to_vendor ,l_currency_code

Line 1999: open attachments_cursor('PO_RELEASES', l_document_id);

1995: -- Getting the header level text information and displaying it if it exists
1996: if (l_document_type = 'PO') then
1997: open attachments_cursor('PO_HEADERS', l_document_id);
1998: elsif (l_document_type = 'RELEASE') then
1999: open attachments_cursor('PO_RELEASES', l_document_id);
2000: else
2001: null;
2002: end if;
2003: loop

Line 2054: select po_header_id into l_po_header_id from po_releases

2050: -- Getting the header level text information and displaying it if it exists
2051: -- for the blanket to which this release is sourced
2052: if (l_document_type = 'RELEASE') THEN
2053:
2054: select po_header_id into l_po_header_id from po_releases
2055: where po_release_id = l_document_id;
2056:
2057: open attachments_cursor('PO_HEADERS', l_po_header_id);
2058:

Line 2646: l_release_num PO_RELEASES_ALL.RELEASE_NUM%TYPE;

2642:
2643:
2644: l_po_number PO_HEADERS_ALL.SEGMENT1%TYPE;
2645: l_po_revision NUMBER;
2646: l_release_num PO_RELEASES_ALL.RELEASE_NUM%TYPE;
2647:
2648: l_date_of_order VARCHAR2(80);
2649: l_buyer per_all_people_f.full_name%TYPE; --bug 15957689
2650: l_date_of_revision VARCHAR2(80);

Line 2833: select po_header_id into l_po_header_id from po_releases_all

2829: /* Bug# 3046054: kagarwal
2830: ** Desc: The org_context is not yet set hence need to use the _all table
2831: */
2832:
2833: select po_header_id into l_po_header_id from po_releases_all
2834: where po_release_id = l_document_id;
2835:
2836: select authorization_status
2837: into l_document_status

Line 3210: select po_header_id into l_po_header_id from po_releases

3206:
3207: IF (l_document_type = 'RELEASE') THEN
3208:
3209:
3210: select po_header_id into l_po_header_id from po_releases
3211: where po_release_id = l_document_id;
3212:
3213: /*BUG 9858430
3214: select org_id into l_operating_unit_id from po_headers

Line 3570: from po_releases

3566: to_char(revised_date ,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK',fnd_global.user_id),
3567: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
3568: revision_num
3569: into l_release_num, l_date_of_revision, l_po_revision
3570: from po_releases
3571: where po_release_id = l_document_id;
3572:
3573: /* Fix for 2341675 by davidng */
3574: select to_char(release_date , FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK',fnd_global.user_id),

Line 3577: from po_releases

3573: /* Fix for 2341675 by davidng */
3574: select to_char(release_date , FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK',fnd_global.user_id),
3575: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN') || '''')
3576: into l_date_of_order
3577: from po_releases
3578: where po_release_id = l_document_id;
3579: /* End fix*/
3580:
3581: exception

Line 3730: -- Need to obtain the buyers from po_headers_archive and po_releases_archive

3726: when no_data_found then
3727: null;
3728: end;
3729:
3730: -- Need to obtain the buyers from po_headers_archive and po_releases_archive
3731: -- for global buyer's need to get buyer name from per_employees_current_x
3732: if (l_document_type in ('PO', 'PA')) THEN
3733: -- there will be an entry in this table regardless of whether there is a revision
3734: -- or not

Line 3782: where person_id = (select agent_id from po_releases_archive

3778: -- or not
3779: begin
3780: select full_name into l_buyer
3781: from per_all_people_f --
3782: where person_id = (select agent_id from po_releases_archive
3783: where po_release_id = to_number(l_document_id) and
3784: revision_num = 0)
3785: and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date); --Bug#5161502
3786: exception

Line 3796: where person_id = (select agent_id from po_releases_archive

3792: begin
3793: if (l_po_revision > 0) then
3794: select full_name into l_revision_buyer
3795: from per_all_people_f --
3796: where person_id = (select agent_id from po_releases_archive
3797: where po_release_id = to_number(l_document_id) and
3798: revision_num = l_po_revision)
3799: and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date); --Bug#5161502
3800: else

Line 4659: select po_header_id into l_po_header_id from po_releases

4655: where po_header_id = l_document_id;
4656:
4657: elsif (l_document_type = 'RELEASE') then
4658:
4659: select po_header_id into l_po_header_id from po_releases
4660: where po_release_id = l_document_id;
4661:
4662: select authorization_status
4663: into l_document_status