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 FND_DOCUMENTS_LONG_TEXT

Line 5303: fnd_documents_long_text fdl

5299:
5300: l_headerAttachmentsQuery := 'select PO_COMMUNICATION_PVT.get_clob(fdl.rowid) long_text
5301: FROM
5302: fnd_attached_docs_form_vl fad,
5303: fnd_documents_long_text fdl
5304: WHERE ( (entity_name=''PO_RELEASES'' AND
5305: pk1_value= to_char(PO_COMMUNICATION_PVT.getDocumentId()) ) OR
5306: (entity_name = ''PO_HEADERS'' AND
5307: pk1_value = to_char(PO_COMMUNICATION_PVT.getReleaseHeaderId())) OR --Bug6139548

Line 5327: fnd_documents_long_text fdl

5323:
5324: l_headerAttachmentsQuery := 'select PO_COMMUNICATION_PVT.get_clob(fdl.rowid) long_text
5325: FROM
5326: fnd_attached_docs_form_vl fad,
5327: fnd_documents_long_text fdl
5328: WHERE ((entity_name = ''PO_HEADERS'' AND
5329: pk1_value = to_char(PO_COMMUNICATION_PVT.getReleaseHeaderId())) OR --Bug6139548
5330: (entity_name = ''PO_VENDORS'' AND
5331: pk1_value = to_char(PO_COMMUNICATION_PVT.getVendorId()))) AND

Line 5352: fnd_documents_long_text fds,

5348:
5349: l_lineAttachQuery :='SELECT PO_COMMUNICATION_PVT.get_clob(fds.rowid) text, plx.po_line_id id
5350: FROM
5351: fnd_attached_docs_form_vl fad,
5352: fnd_documents_long_text fds,
5353: po_lines_all plx
5354: WHERE ((fad.entity_name=''PO_LINES'' AND fad.pk1_value=to_char(plx.po_line_id))
5355: OR
5356: (fad.entity_name=''MTL_SYSTEM_ITEMS'' AND

Line 5381: fnd_documents_long_text fds,

5377: as this text is already printed as shipto Location */
5378: l_shipmentAttachmentQuery:= 'SELECT PO_COMMUNICATION_PVT.get_clob(fds.rowid) long_text, pllx.LINE_LOCATION_ID
5379: FROM
5380: fnd_attached_docs_form_vl fad,
5381: fnd_documents_long_text fds,
5382: po_line_locations_all pllx
5383: WHERE entity_name = ''PO_SHIPMENTS'' AND
5384: pk1_value = to_char(pllx.LINE_LOCATION_ID) AND
5385: function_name = ''PO_PRINTPO''

Line 7213: fnd_documents_long_text fds

7209: BEGIN
7210: SELECT fds.long_text INTO
7211: l_long
7212: FROM
7213: fnd_documents_long_text fds
7214: WHERE fds.ROWID= p_row_id;
7215:
7216: l_clob := l_long;
7217:

Line 7258: fnd_documents_long_text fds

7254: INTO
7255: l_one_time_address_details
7256: FROM
7257: fnd_attached_docs_form_vl fad,
7258: fnd_documents_long_text fds
7259: WHERE entity_name = 'PO_SHIPMENTS' AND
7260: pk1_value = To_Char(p_line_location_id) AND
7261: function_name = 'PO_PRINTPO'
7262: AND fad.media_id = fds.media_id