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 2231: Last_update_date fnd_attached_documents.last_update_date%TYPE,

2227: l_site_id number;
2228: i number;
2229:
2230: TYPE local_rrs_site_attachment_rec is RECORD (
2231: Last_update_date fnd_attached_documents.last_update_date%TYPE,
2232: Last_updated_by_name fnd_user.user_name%TYPE,
2233: Entity_name fnd_attached_documents.Entity_name%TYPE,
2234: site_id fnd_attached_documents.pk1_value%TYPE,
2235: datatype_id fnd_documents.datatype_id%TYPE,

Line 2233: Entity_name fnd_attached_documents.Entity_name%TYPE,

2229:
2230: TYPE local_rrs_site_attachment_rec is RECORD (
2231: Last_update_date fnd_attached_documents.last_update_date%TYPE,
2232: Last_updated_by_name fnd_user.user_name%TYPE,
2233: Entity_name fnd_attached_documents.Entity_name%TYPE,
2234: site_id fnd_attached_documents.pk1_value%TYPE,
2235: datatype_id fnd_documents.datatype_id%TYPE,
2236: datatype_name fnd_document_datatypes.user_name%TYPE,
2237: description fnd_documents_tl.description%TYPE,

Line 2234: site_id fnd_attached_documents.pk1_value%TYPE,

2230: TYPE local_rrs_site_attachment_rec is RECORD (
2231: Last_update_date fnd_attached_documents.last_update_date%TYPE,
2232: Last_updated_by_name fnd_user.user_name%TYPE,
2233: Entity_name fnd_attached_documents.Entity_name%TYPE,
2234: site_id fnd_attached_documents.pk1_value%TYPE,
2235: datatype_id fnd_documents.datatype_id%TYPE,
2236: datatype_name fnd_document_datatypes.user_name%TYPE,
2237: description fnd_documents_tl.description%TYPE,
2238: file_name fnd_documents_tl.file_name%TYPE,

Line 2244: category_id fnd_attached_documents.category_id%TYPE,

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

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

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

Line 2311: FND_ATTACHED_DOCUMENTS ad,

2307: d.TITLE
2308: BULK COLLECT
2309: INTO l_attachment_details
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