APPS.RRS_SITE_INFO dependencies on FND_DOCUMENT_CATEGORIES_TL

Line 2318: attachment_category_name fnd_document_categories_tl.user_name%TYPE,

2314: dm_folder_path fnd_documents.dm_folder_path%TYPE,
2315: data_object_code fnd_document_entities.data_object_code%TYPE,
2316: document_entity_id fnd_document_entities.document_entity_id%TYPE,
2317: category_id fnd_attached_documents.category_id%TYPE,
2318: attachment_category_name fnd_document_categories_tl.user_name%TYPE,
2319: status fnd_attached_documents.status%TYPE,
2320: attached_by_name fnd_user.user_name%TYPE,
2321: file_name_sort fnd_documents.URL%TYPE,
2322: usage_type fnd_documents.usage_type%TYPE,

Line 2325: cat_id_query fnd_document_categories_tl.category_id%TYPE,

2321: file_name_sort fnd_documents.URL%TYPE,
2322: usage_type fnd_documents.usage_type%TYPE,
2323: security_type fnd_documents.security_type%TYPE,
2324: publish_flag fnd_documents.publish_flag%TYPE,
2325: cat_id_query fnd_document_categories_tl.category_id%TYPE,
2326: seq_num fnd_attached_documents.seq_num%TYPE,
2327: url fnd_documents.URL%TYPE,
2328: title fnd_documents_tl.title%TYPE
2329: );

Line 2387: FND_DOCUMENT_CATEGORIES_TL cl,

2383: FROM FND_DOCUMENTS_VL d,
2384: FND_ATTACHED_DOCUMENTS ad,
2385: FND_DOCUMENT_ENTITIES e,
2386: FND_USER u,
2387: FND_DOCUMENT_CATEGORIES_TL cl,
2388: FND_DM_NODES node
2389: WHERE ad.DOCUMENT_ID = d.DOCUMENT_ID
2390: and ad.ENTITY_NAME = e.DATA_OBJECT_CODE(+)
2391: and ad.LAST_UPDATED_BY = u.USER_ID(+)