DBA Data[Home] [Help]

APPS.PO_COMMUNICATION_PVT dependencies on FND_ATTACHMENT_FUNCTIONS

Line 1147: fnd_attachment_functions af,

1143: select fl.file_name,dbms_lob.getlength(fl.file_data)
1144: from fnd_documents d,
1145: fnd_attached_documents ad,
1146: fnd_doc_category_usages dcu,
1147: fnd_attachment_functions af,
1148: fnd_lobs fl
1149: where ((ad.pk1_value=to_char(l_po_header_id) and ad.entity_name='PO_HEADERS')
1150: OR
1151: (ad.pk1_value=to_char((select vendor_id from po_headers_all

Line 1196: fnd_attachment_functions af,

1192: select fl.file_name,dbms_lob.getlength(fl.file_data)
1193: from fnd_documents d,
1194: fnd_attached_documents ad,
1195: fnd_doc_category_usages dcu,
1196: fnd_attachment_functions af,
1197: fnd_lobs fl
1198: where ((ad.pk1_value=to_char((select po_header_id from po_releases_all
1199: where po_release_id=l_po_release_id
1200: )) and ad.entity_name='PO_HEADERS')

Line 1384: fnd_attachment_functions af,

1380: select fl.file_name
1381: from fnd_documents d,
1382: fnd_attached_documents ad,
1383: fnd_doc_category_usages dcu,
1384: fnd_attachment_functions af,
1385: fnd_lobs fl
1386: where ((ad.pk1_value=to_char((select po_header_id from po_releases_all
1387: where po_release_id=l_document_id
1388: )) and ad.entity_name='PO_HEADERS')

Line 1447: fnd_attachment_functions af,

1443: select fl.file_name
1444: from fnd_documents d,
1445: fnd_attached_documents ad,
1446: fnd_doc_category_usages dcu,
1447: fnd_attachment_functions af,
1448: fnd_lobs fl
1449: where ((ad.pk1_value=to_char(l_document_id) and ad.entity_name='PO_HEADERS')
1450: OR
1451: (ad.pk1_value=to_char((select vendor_id from po_headers_all

Line 3977: fnd_attachment_functions af,

3973: select fl.file_name
3974: from fnd_documents d,
3975: fnd_attached_documents ad,
3976: fnd_doc_category_usages dcu,
3977: fnd_attachment_functions af,
3978: fnd_lobs fl
3979: where ((ad.pk1_value=to_char((select po_header_id from po_releases_all
3980: where po_release_id=p_document_id
3981: )) and ad.entity_name='PO_HEADERS')

Line 4030: fnd_attachment_functions af,

4026: select fl.file_name
4027: from fnd_documents d,
4028: fnd_attached_documents ad,
4029: fnd_doc_category_usages dcu,
4030: fnd_attachment_functions af,
4031: fnd_lobs fl
4032: where ((ad.pk1_value=to_char(p_document_id) and ad.entity_name='PO_HEADERS')
4033: OR
4034: (ad.pk1_value=to_char((select vendor_id from po_headers_all