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.EAM_SAFETY_REPORTS_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 240: fnd_attached_documents fad

236: fdv.description AS "TEXT_DESC",
237: fdv.category_description AS "TEXT_CATEGORY")) textAttachment
238: FROM fnd_documents_short_text fdst,
239: fnd_documents_vl fdv,
240: fnd_attached_documents fad
241: WHERE fdst.media_id = fdv.media_id
242: AND fad.document_id = fdv.document_id
243: AND fad.entity_name = 'EAM_WORK_PERMIT'
244: AND fad.pk1_value = p_org_id

Line 257: fnd_attached_documents fad

253: fdv.description AS "URL_DESC",
254: fdv.category_description AS "URL_CATEGORY")) urlAttachment
255: FROM
256: fnd_documents_vl fdv,
257: fnd_attached_documents fad
258: WHERE
259: fad.document_id = fdv.document_id
260: AND fad.entity_name = 'EAM_WORK_PERMIT'
261: AND fad.pk1_value = p_org_id

Line 273: fnd_attached_documents fad

269: XMLFOREST( fdv.file_name AS "FILE_NAME",
270: fdv.description AS "FILE_DESC",
271: fdv.category_description AS "FILE_CATEGORY")) fileAttachment
272: FROM fnd_documents_vl fdv,
273: fnd_attached_documents fad
274: WHERE fad.document_id = fdv.document_id
275: AND fad.entity_name = 'EAM_WORK_PERMIT'
276: AND fad.pk1_value = p_org_id
277: AND fad.pk2_value = p_permit_id