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 261: fnd_documents_vl fdv,

257: --fad.entity_name as "AENTITYNAME",
258: /*fad.attached_document_id as "ATTACHWORKDOCID"*/)) ShortAttachment
259: from
260: FND_DOCUMENTS_SHORT_TEXT fdst,
261: fnd_documents_vl fdv,
262: fnd_attached_documents fad
263: where
264: fdst.media_id = fdv.media_id and
265: --fdv.datatype_name = 'Short Text' and

Line 293: fnd_documents_vl fdv,

289: --fad.entity_name as "AENTITYNAME",
290: /*fad.attached_document_id as "ATTACHWORKDOCID"*/) LongAttachment
291: from
292: FND_DOCUMENTS_LONG_TEXT fdlt,
293: fnd_documents_vl fdv,
294: fnd_attached_documents fad
295: where
296: fdlt.media_id = fdv.media_id and
297: fdv.datatype_name = 'Long Text' and

Line 314: fnd_documents_vl fdv,

310: fdv.category_description as "OPASHORTCATEGORY",
311: fad.pk2_value as "OPASEQNO")) OpShortAttachment
312: from
313: FND_DOCUMENTS_SHORT_TEXT fdst,
314: fnd_documents_vl fdv,
315: fnd_attached_documents fad
316: where fdst.media_id = fdv.media_id
317: and fad.document_id = fdv.document_id
318: and fad.entity_name = 'EAM_DISCRETE_OPERATIONS'

Line 334: fnd_documents_vl fdv,

330: fdv.category_description as "OPALONGWORKCATEGORY",
331: fad.pk2_value as "OPALONGSEQNUM") OpLongAttachment
332: from
333: FND_DOCUMENTS_LONG_TEXT fdlt,
334: fnd_documents_vl fdv,
335: fnd_attached_documents fad
336: where
337: fdlt.media_id = fdv.media_id and
338: fad.document_id = fdv.document_id and

Line 352: fnd_documents_vl fdv,

348: fdv.file_name as "AFILEWORKNAME",
349: fdv.description as "AFILEWORKDESC",
350: fdv.category_description as "AFILEWORKCATEGORY")) FileAttachment
351: from
352: fnd_documents_vl fdv,
353: fnd_attached_documents fad
354: where
355: fad.document_id = fdv.document_id and
356: fad.entity_name = 'EAM_WORK_ORDERS' and

Line 1324: fnd_documents_vl fdv,

1320: (select
1321: fdlt.long_text
1322: from
1323: FND_DOCUMENTS_LONG_TEXT fdlt,
1324: fnd_documents_vl fdv,
1325: fnd_attached_documents fad
1326: where
1327: fdlt.media_id = fdv.media_id and
1328: fad.document_id = fdv.document_id and

Line 1343: fnd_documents_vl fdv,

1339: insert into EAM_WOREP_LONG_ATTACH_TEMP (select
1340: fdlt.long_text
1341: from
1342: FND_DOCUMENTS_LONG_TEXT fdlt,
1343: fnd_documents_vl fdv,
1344: fnd_attached_documents fad
1345: where
1346: fdlt.media_id = fdv.media_id and
1347: fad.document_id = fdv.document_id and