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_WORKORDERREP_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 253: fnd_attached_documents fad

249: /*fad.attached_document_id as "ATTACHWORKDOCID"*/)) ShortAttachment
250: from
251: FND_DOCUMENTS_SHORT_TEXT fdst,
252: fnd_documents_vl fdv,
253: fnd_attached_documents fad
254: where
255: fdst.media_id = fdv.media_id and
256: fad.document_id = fdv.document_id and
257: fad.entity_name = 'EAM_WORK_ORDERS' and

Line 280: fnd_attached_documents fad

276: /*fad.attached_document_id as "ATTACHWORKDOCID"*/) LongAttachment
277: from
278: FND_DOCUMENTS_LONG_TEXT fdlt,
279: fnd_documents_vl fdv,
280: fnd_attached_documents fad
281: where
282: fdlt.media_id = fdv.media_id and
283: fad.document_id = fdv.document_id and
284: fad.entity_name = 'EAM_WORK_ORDERS' and

Line 300: fnd_attached_documents fad

296: fad.pk2_value as "OPASEQNO")) OpShortAttachment
297: from
298: FND_DOCUMENTS_SHORT_TEXT fdst,
299: fnd_documents_vl fdv,
300: fnd_attached_documents fad
301: where fdst.media_id = fdv.media_id
302: and fad.document_id = fdv.document_id
303: and fad.entity_name = 'EAM_DISCRETE_OPERATIONS'
304: and fad.pk1_value=p_wip_id

Line 319: fnd_attached_documents fad

315: fad.pk2_value as "OPALONGSEQNUM") OpLongAttachment
316: from
317: FND_DOCUMENTS_LONG_TEXT fdlt,
318: fnd_documents_vl fdv,
319: fnd_attached_documents fad
320: where
321: fdlt.media_id = fdv.media_id and
322: fad.document_id = fdv.document_id and
323: fad.entity_name = 'EAM_DISCRETE_OPERATIONS' and

Line 336: fnd_attached_documents fad

332: fdv.description as "AFILEWORKDESC",
333: fdv.category_description as "AFILEWORKCATEGORY")) FileAttachment
334: from
335: fnd_documents_vl fdv,
336: fnd_attached_documents fad
337: where
338: fad.document_id = fdv.document_id and
339: fad.entity_name = 'EAM_WORK_ORDERS' and
340: fad.pk1_value=p_org_id and

Line 1068: fnd_attached_documents fad

1064: execute immediate 'insert into temp_val (select to_lob(fdlt.long_text)
1065: from
1066: FND_DOCUMENTS_LONG_TEXT fdlt,
1067: fnd_documents_vl fdv,
1068: fnd_attached_documents fad
1069: where
1070: fdlt.media_id = fdv.media_id and
1071: fad.document_id = fdv.document_id and
1072: fad.entity_name =' || ' ''EAM_WORK_ORDERS'' ' || 'and

Line 1085: fnd_attached_documents fad

1081: execute immediate 'insert into temp_val (select to_lob(fdlt.long_text)
1082: from
1083: FND_DOCUMENTS_LONG_TEXT fdlt,
1084: fnd_documents_vl fdv,
1085: fnd_attached_documents fad
1086: where
1087: fdlt.media_id = fdv.media_id and
1088: fad.document_id = fdv.document_id and
1089: fad.entity_name =' || ' ''EAM_DISCRETE_OPERATIONS'' ' || 'and