DBA Data[Home] [Help]

APPS.PON_FBO_PKG dependencies on FND_DOCUMENT_CATEGORIES

Line 601: fnd_document_categories doccat

597: fl.file_name as description
598: FROM fnd_attached_documents fad,
599: fnd_documents_vl fdvl,
600: fnd_lobs fl,
601: fnd_document_categories doccat
602: WHERE fad.document_id = fdvl.document_id
603: and fdvl.category_id = doccat.category_id
604: and doccat.name = l_doccat_name
605: AND fad.entity_name = 'PON_AUCTION_HEADERS_ALL'

Line 777: fnd_document_categories doccat

773: fl.file_name as description
774: FROM fnd_attached_documents fad,
775: fnd_documents_vl fdvl,
776: fnd_lobs fl,
777: fnd_document_categories doccat
778: WHERE fad.document_id = fdvl.document_id
779: and fdvl.category_id = doccat.category_id
780: and doccat.name = 'ToFedBizOppsSecure'
781: AND fad.entity_name = 'PON_AUCTION_HEADERS_ALL'

Line 924: fnd_document_categories doccat

920: fl.file_name as description
921: FROM fnd_attached_documents fad,
922: fnd_documents_vl fdvl,
923: fnd_lobs fl,
924: fnd_document_categories doccat
925: WHERE fad.document_id = fdvl.document_id
926: and fdvl.category_id = doccat.category_id
927: and doccat.name in ('ToFedBizOpps','Vendor')
928: AND fad.entity_name = 'PON_AUCTION_HEADERS_ALL'