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 FND_ATTACHED_DOCS_FORM_VL

Line 121: l_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;

117: l_item_short_text FND_DOCUMENTS_SHORT_TEXT.SHORT_TEXT%TYPE := null;
118: l_item_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
119:
120: l_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
121: l_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
122: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;
123: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
124: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;
125: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;

Line 122: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;

118: l_item_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
119:
120: l_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
121: l_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
122: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;
123: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
124: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;
125: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;
126: l_cancel_date po_line_locations_all.cancel_date%TYPE;

Line 123: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;

119:
120: l_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
121: l_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
122: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;
123: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
124: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;
125: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;
126: l_cancel_date po_line_locations_all.cancel_date%TYPE;
127: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;

Line 124: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;

120: l_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
121: l_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
122: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;
123: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
124: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;
125: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;
126: l_cancel_date po_line_locations_all.cancel_date%TYPE;
127: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;
128:

Line 194: from fnd_attached_docs_form_vl

190: /* bug 4567441 : added the orderby clause, so that the document attachments
191: are ordered by sequence */
192: cursor attachments_cursor(v_entity_name varchar2, v_document_id number) is
193: Select datatype_id, media_id
194: from fnd_attached_docs_form_vl
195: where entity_name = v_entity_name
196: and pk1_value = to_char(v_document_id) /* Bug 5964375 */
197: and function_name = 'PO_PRINTPO'
198: and datatype_id in (1,2)

Line 210: from fnd_attached_docs_form_vl fad, financials_system_parameters fsp

206: /* bug 4567441 : added the orderby clause, so that the document attachments
207: are ordered by sequence */
208: cursor attachments_from_ga_cursor(v_entity_name varchar2, v_document_id number) is
209: Select datatype_id, media_id
210: from fnd_attached_docs_form_vl fad, financials_system_parameters fsp
211: where entity_name = v_entity_name
212: and pk1_value = to_char(v_document_id) /* Bug 5964375 */
213: and function_name = 'PO_PRINTPO'
214: and datatype_id in (1,2)

Line 231: FROM fnd_attached_docs_form_vl

227: are ordered by sequence */
228: cursor item_notes_cursor(v_org_id number, v_item_id number) is
229: SELECT datatype_id,
230: media_id
231: FROM fnd_attached_docs_form_vl
232: WHERE entity_name = 'MTL_SYSTEM_ITEMS' AND
233: pk1_value = to_char(v_org_id) AND
234: pk2_value = to_char(v_item_id) AND
235: function_name = 'PO_PRINTPO' and