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_DOCUMENTS_VL

Line 252: fnd_documents_vl fdv,

248: --fad.entity_name as "AENTITYNAME",
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

Line 279: fnd_documents_vl fdv,

275: --fad.entity_name as "AENTITYNAME",
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

Line 299: fnd_documents_vl fdv,

295: fdv.category_description as "OPASHORTCATEGORY",
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'

Line 318: fnd_documents_vl fdv,

314: fdv.category_description as "OPALONGWORKCATEGORY",
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

Line 335: fnd_documents_vl fdv,

331: fdv.file_name as "AFILEWORKNAME",
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

Line 1067: fnd_documents_vl fdv,

1063: execute immediate 'create table temp_val(long_text clob)';
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

Line 1084: fnd_documents_vl fdv,

1080: execute immediate 'create table temp_val(long_text clob)';
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