DBA Data[Home] [Help]

APPS.PO_AME_WF_PVT dependencies on FND_DOC_CATEGORY_USAGES

Line 3192: fnd_doc_category_usages dcu,

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)

Line 3356: fnd_doc_category_usages dcu,

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: --