3188: CURSOR l_get_po_attachments_csr(l_po_header_id NUMBER) IS
3189: SELECT fl.file_name, dbms_lob.getlength(fl.file_data)
3190: FROM fnd_documents d,
3191: fnd_attached_documents ad,
3192: fnd_doc_category_usages dcu,
3193: fnd_attachment_functions af,
3194: fnd_lobs fl
3195: WHERE ( (ad.pk1_value = TO_CHAR(l_po_header_id) AND ad.entity_name = 'PO_HEADERS') OR
3196: (ad.pk1_value = (SELECT To_Char(vendor_id)
3352: FROM dual
3353: WHERE EXISTS ( SELECT fl.file_name
3354: FROM fnd_documents d,
3355: fnd_attached_documents ad,
3356: fnd_doc_category_usages dcu,
3357: fnd_attachment_functions af,
3358: fnd_lobs fl
3359: WHERE ( (ad.pk1_value = TO_CHAR(l_document_id) AND ad.entity_name = 'PO_HEADERS') OR
3360: --