APPS.RRS_SITE_INFO dependencies on FND_DOCUMENT_CATEGORIES_TL

Line 2245: attachment_category_name fnd_document_categories_tl.user_name%TYPE,

2241: dm_folder_path fnd_documents.dm_folder_path%TYPE,
2242: data_object_code fnd_document_entities.data_object_code%TYPE,
2243: document_entity_id fnd_document_entities.document_entity_id%TYPE,
2244: category_id fnd_attached_documents.category_id%TYPE,
2245: attachment_category_name fnd_document_categories_tl.user_name%TYPE,
2246: status fnd_attached_documents.status%TYPE,
2247: attached_by_name fnd_user.user_name%TYPE,
2248: file_name_sort fnd_documents.URL%TYPE,
2249: usage_type fnd_documents.usage_type%TYPE,

Line 2252: cat_id_query fnd_document_categories_tl.category_id%TYPE,

2248: file_name_sort fnd_documents.URL%TYPE,
2249: usage_type fnd_documents.usage_type%TYPE,
2250: security_type fnd_documents.security_type%TYPE,
2251: publish_flag fnd_documents.publish_flag%TYPE,
2252: cat_id_query fnd_document_categories_tl.category_id%TYPE,
2253: seq_num fnd_attached_documents.seq_num%TYPE,
2254: url fnd_documents.URL%TYPE,
2255: title fnd_documents_tl.title%TYPE
2256: );

Line 2314: FND_DOCUMENT_CATEGORIES_TL cl,

2310: FROM FND_DOCUMENTS_VL d,
2311: FND_ATTACHED_DOCUMENTS ad,
2312: FND_DOCUMENT_ENTITIES e,
2313: FND_USER u,
2314: FND_DOCUMENT_CATEGORIES_TL cl,
2315: FND_DM_NODES node
2316: WHERE ad.DOCUMENT_ID = d.DOCUMENT_ID
2317: and ad.ENTITY_NAME = e.DATA_OBJECT_CODE(+)
2318: and ad.LAST_UPDATED_BY = u.USER_ID(+)