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.CSD_REPAIRS_PVT dependencies on FND_DOCUMENTS_TL

Line 3033: fnd_documents_tl fdtl

3029: fdtl.doc_attribute14 dattr14,
3030: fdtl.doc_attribute15 dattr15
3031: FROM fnd_attached_documents fad,
3032: fnd_documents fd,
3033: fnd_documents_tl fdtl
3034: WHERE fad.document_id = fd.document_id
3035: AND fd.document_id = fdtl.document_id
3036: AND fdtl.LANGUAGE = USERENV('LANG')
3037: AND fad.pk1_value = TO_CHAR(p_original_ro_id);

Line 3577: FROM fnd_documents_tl fdtl,

3573:
3574: DELETE FROM fnd_documents_short_text
3575: WHERE media_id IN
3576: (SELECT fdtl.media_id
3577: FROM fnd_documents_tl fdtl,
3578: fnd_documents fd,
3579: fnd_attached_documents fad
3580: WHERE fdtl.document_id = fd.document_id
3581: AND fd.document_id = fad.document_id

Line 3596: FROM fnd_documents_tl fdtl,

3592:
3593: DELETE FROM fnd_documents_long_text
3594: WHERE media_id IN
3595: (SELECT fdtl.media_id
3596: FROM fnd_documents_tl fdtl,
3597: fnd_documents fd,
3598: fnd_attached_documents fad
3599: WHERE fdtl.document_id = fd.document_id
3600: AND fd.document_id = fad.document_id

Line 3615: FROM fnd_documents_tl fdtl,

3611:
3612: DELETE FROM fnd_documents_long_raw
3613: WHERE media_id IN
3614: (SELECT fdtl.media_id
3615: FROM fnd_documents_tl fdtl,
3616: fnd_documents fd,
3617: fnd_attached_documents fad
3618: WHERE fdtl.document_id = fd.document_id
3619: AND fd.document_id = fad.document_id

Line 3635: FROM fnd_documents_tl fdtl,

3631:
3632: DELETE FROM fnd_lobs
3633: WHERE file_id IN
3634: (SELECT fdtl.media_id
3635: FROM fnd_documents_tl fdtl,
3636: fnd_documents fd,
3637: fnd_attached_documents fad
3638: WHERE fdtl.document_id = fd.document_id
3639: AND fd.document_id = fad.document_id

Line 3644: -- Delete from FND_DOCUMENTS_TL table

3640: AND fd.usage_type = 'O'
3641: AND fd.datatype_id = 6
3642: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3643:
3644: -- Delete from FND_DOCUMENTS_TL table
3645: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3646: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3647: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3648: 'Deleting from fnd_documents_tl');

Line 3648: 'Deleting from fnd_documents_tl');

3644: -- Delete from FND_DOCUMENTS_TL table
3645: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3646: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3647: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3648: 'Deleting from fnd_documents_tl');
3649: END IF;
3650:
3651: DELETE FROM fnd_documents_tl
3652: WHERE document_id IN

Line 3651: DELETE FROM fnd_documents_tl

3647: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3648: 'Deleting from fnd_documents_tl');
3649: END IF;
3650:
3651: DELETE FROM fnd_documents_tl
3652: WHERE document_id IN
3653: (SELECT fad.document_id
3654: FROM fnd_attached_documents fad, fnd_documents fd
3655: WHERE fad.document_id = fd.document_id