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 6188: fnd_documents_long_text fdl

6184:
6185: l_headerAttachmentsQuery := 'select fdl.long_text long_text
6186: FROM
6187: fnd_attached_docs_form_vl fad,
6188: fnd_documents_long_text fdl
6189: WHERE ( (entity_name=''PO_RELEASES'' AND
6190: pk1_value= to_char(PO_COMMUNICATION_PVT.getDocumentId()) ) OR
6191: (entity_name = ''PO_HEADERS'' AND
6192: pk1_value = to_char(PO_COMMUNICATION_PVT.getReleaseHeaderId())) OR --Bug6139548

Line 6212: fnd_documents_long_text fdl

6208:
6209: l_headerAttachmentsQuery := 'select fdl.long_text long_text
6210: FROM
6211: fnd_attached_docs_form_vl fad,
6212: fnd_documents_long_text fdl
6213: WHERE ((entity_name = ''PO_HEADERS'' AND
6214: pk1_value = to_char(PO_COMMUNICATION_PVT.getReleaseHeaderId())) OR --Bug6139548
6215: (entity_name = ''PO_VENDORS'' AND
6216: pk1_value = to_char(PO_COMMUNICATION_PVT.getVendorId()))) AND

Line 6241: fnd_documents_long_text fds,

6237:
6238: /*l_lineAttachQuery :='SELECT fds.long_text text, plx.po_line_id id
6239: FROM
6240: fnd_attached_docs_form_vl fad,
6241: fnd_documents_long_text fds,
6242: po_lines_all plx
6243: WHERE ((fad.entity_name=''PO_LINES'' AND fad.pk1_value=to_char(plx.po_line_id))
6244: OR
6245: (fad.entity_name=''PO_HEADERS'' AND fad.pk1_value=to_char(plx.from_header_id)

Line 6273: FROM fnd_documents_long_text fds ,

6269: -- Bug 14476193 : Changing condition DT.media_id = fds.media_id to D.media_id = fds.media_id
6270: l_lineAttachQuery :='select text, id from
6271: (SELECT /*+ leading (plx ad) use_nl(ad)*/
6272: fds.long_text text , plx.po_line_id id, seq_num
6273: FROM fnd_documents_long_text fds ,
6274: FND_ATTACHED_DOCUMENTS AD,
6275: FND_DOCUMENTS_TL DT ,
6276: FND_DOCUMENTS D ,
6277: FND_ATTACHMENT_FUNCTIONS AF,

Line 6294: FROM fnd_documents_long_text fds ,

6290: AND plx.po_header_id = PO_COMMUNICATION_PVT.getReleaseHeaderId ()
6291: UNION ALL
6292: SELECT /*+ leading (plx ad) use_nl(ad) */
6293: fds.long_text text , plx.po_line_id id, seq_num
6294: FROM fnd_documents_long_text fds ,
6295: FND_ATTACHED_DOCUMENTS AD,
6296: FND_DOCUMENTS_TL DT ,
6297: FND_DOCUMENTS D ,
6298: FND_ATTACHMENT_FUNCTIONS AF,

Line 6316: FROM fnd_documents_long_text fds ,

6312: AND plx.po_header_id = PO_COMMUNICATION_PVT.getReleaseHeaderId ()
6313: UNION ALL
6314: SELECT /*+ leading (plx ad) use_nl(ad) */
6315: fds.long_text text , plx.po_line_id id, seq_num
6316: FROM fnd_documents_long_text fds ,
6317: FND_ATTACHED_DOCUMENTS AD,
6318: FND_DOCUMENTS_TL DT ,
6319: FND_DOCUMENTS D ,
6320: FND_ATTACHMENT_FUNCTIONS AF,

Line 6338: FROM fnd_documents_long_text fds ,

6334: AND plx.po_header_id = PO_COMMUNICATION_PVT.getReleaseHeaderId ()
6335: UNION ALL
6336: SELECT /*+ leading (plx ad) use_nl(ad) */
6337: fds.long_text text , plx.po_line_id id, seq_num
6338: FROM fnd_documents_long_text fds ,
6339: FND_ATTACHED_DOCUMENTS AD,
6340: FND_DOCUMENTS_TL DT ,
6341: FND_DOCUMENTS D ,
6342: FND_ATTACHMENT_FUNCTIONS AF,

Line 6360: FROM fnd_documents_long_text fds ,

6356: AND plx.po_header_id = PO_COMMUNICATION_PVT.getReleaseHeaderId ()
6357: UNION ALL
6358: SELECT /*+ leading (plx ad) use_nl(ad) */
6359: fds.long_text text , plx.po_line_id id , seq_num
6360: FROM fnd_documents_long_text fds ,
6361: FND_ATTACHED_DOCUMENTS AD,
6362: FND_DOCUMENTS_TL DT ,
6363: FND_DOCUMENTS D ,
6364: FND_ATTACHMENT_FUNCTIONS AF,

Line 6402: fnd_documents_long_text fds,

6398: -- Rewriting the following query for performance improvements.
6399: /*l_shipmentAttachmentQuery := 'SELECT fds.long_text long_text, pllx.LINE_LOCATION_ID
6400: FROM
6401: fnd_attached_docs_form_vl fad,
6402: fnd_documents_long_text fds,
6403: po_line_locations_all pllx
6404: WHERE entity_name = ''PO_SHIPMENTS'' AND
6405: pk1_value = to_char(pllx.LINE_LOCATION_ID) AND
6406: function_name = ''PO_PRINTPO''

Line 6416: fnd_documents_long_text fds,

6412: */
6413: l_shipmentAttachmentQuery := 'SELECT PO_COMMUNICATION_PVT.get_clob(fds.rowid) long_text, pllx.LINE_LOCATION_ID
6414: FROM
6415: fnd_attached_docs_form_vl fad,
6416: fnd_documents_long_text fds,
6417: po_line_locations_all pllx
6418: WHERE entity_name = ''PO_SHIPMENTS'' AND
6419: pk1_value = to_char(pllx.LINE_LOCATION_ID) AND
6420: function_name = ''PO_PRINTPO''

Line 8408: fnd_documents_long_text fds

8404: BEGIN
8405: SELECT fds.long_text INTO
8406: l_long
8407: FROM
8408: fnd_documents_long_text fds
8409: WHERE fds.ROWID = p_row_id;
8410:
8411: l_clob := l_long;
8412:

Line 8454: fnd_documents_long_text fds

8450: INTO
8451: l_one_time_address_clob
8452: FROM
8453: fnd_attached_docs_form_vl fad,
8454: fnd_documents_long_text fds
8455: WHERE entity_name = 'PO_SHIPMENTS' AND
8456: pk1_value = To_Char(p_line_location_id) AND
8457: function_name = 'PO_PRINTPO'
8458: AND fad.media_id = fds.media_id