eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RRS_SITE_INFO dependencies on FND_ATTACHED_DOCUMENTS

Line 2304: Last_update_date fnd_attached_documents.last_update_date%TYPE,

2300: l_site_id number;
2301: i number;
2302:
2303: TYPE local_rrs_site_attachment_rec is RECORD (
2304: Last_update_date fnd_attached_documents.last_update_date%TYPE,
2305: Last_updated_by_name fnd_user.user_name%TYPE,
2306: Entity_name fnd_attached_documents.Entity_name%TYPE,
2307: site_id fnd_attached_documents.pk1_value%TYPE,
2308: datatype_id fnd_documents.datatype_id%TYPE,

Line 2306: Entity_name fnd_attached_documents.Entity_name%TYPE,

2302:
2303: TYPE local_rrs_site_attachment_rec is RECORD (
2304: Last_update_date fnd_attached_documents.last_update_date%TYPE,
2305: Last_updated_by_name fnd_user.user_name%TYPE,
2306: Entity_name fnd_attached_documents.Entity_name%TYPE,
2307: site_id fnd_attached_documents.pk1_value%TYPE,
2308: datatype_id fnd_documents.datatype_id%TYPE,
2309: datatype_name fnd_document_datatypes.user_name%TYPE,
2310: description fnd_documents_tl.description%TYPE,

Line 2307: site_id fnd_attached_documents.pk1_value%TYPE,

2303: TYPE local_rrs_site_attachment_rec is RECORD (
2304: Last_update_date fnd_attached_documents.last_update_date%TYPE,
2305: Last_updated_by_name fnd_user.user_name%TYPE,
2306: Entity_name fnd_attached_documents.Entity_name%TYPE,
2307: site_id fnd_attached_documents.pk1_value%TYPE,
2308: datatype_id fnd_documents.datatype_id%TYPE,
2309: datatype_name fnd_document_datatypes.user_name%TYPE,
2310: description fnd_documents_tl.description%TYPE,
2311: file_name fnd_documents_tl.file_name%TYPE,

Line 2317: category_id fnd_attached_documents.category_id%TYPE,

2313: dm_node fnd_documents.dm_node%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,

Line 2319: status fnd_attached_documents.status%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,
2323: security_type fnd_documents.security_type%TYPE,

Line 2326: seq_num fnd_attached_documents.seq_num%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: );
2330: TYPE local_rrs_site_attachment_tab IS TABLE OF local_rrs_site_attachment_rec;

Line 2384: FND_ATTACHED_DOCUMENTS ad,

2380: d.TITLE
2381: BULK COLLECT
2382: INTO l_attachment_details
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