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_ATTACHED_DOCUMENTS

Line 3031: FROM fnd_attached_documents fad,

3027: fdtl.doc_attribute12 dattr12,
3028: fdtl.doc_attribute13 dattr13,
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

Line 3332: 'Inserting into fnd_attached_documents for

3328:
3329: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3330: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3331: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3332: 'Inserting into fnd_attached_documents for
3333: document id = '||docrec.document_id);
3334: END IF;
3335:
3336: -- Create attachment record

Line 3337: INSERT INTO fnd_attached_documents

3333: document id = '||docrec.document_id);
3334: END IF;
3335:
3336: -- Create attachment record
3337: INSERT INTO fnd_attached_documents
3338: (attached_document_id,
3339: document_id,
3340: creation_date,
3341: created_by,

Line 3368: fnd_attached_documents_s.NEXTVAL,

3364: attribute13, attribute14,
3365: attribute15,
3366: column1)
3367: (SELECT
3368: fnd_attached_documents_s.NEXTVAL,
3369: docrec.document_id,
3370: SYSDATE,
3371: Fnd_Global.user_id,
3372: SYSDATE,

Line 3397: FROM fnd_attached_documents

3393: docrec.attribute11, docrec.attribute12,
3394: docrec.attribute13, docrec.attribute14,
3395: docrec.attribute15,
3396: docrec.column1
3397: FROM fnd_attached_documents
3398: WHERE attached_document_id = docrec.attached_document_id);
3399:
3400: END LOOP; -- end of working through all attachments
3401:

Line 3579: fnd_attached_documents fad

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
3582: AND fd.usage_type = 'O'
3583: AND fd.datatype_id = 1

Line 3598: fnd_attached_documents fad

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
3601: AND fd.usage_type = 'O'
3602: AND fd.datatype_id = 2

Line 3617: fnd_attached_documents fad

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
3620: AND fd.usage_type = 'O'
3621: AND fd.datatype_id IN (3,4)

Line 3637: fnd_attached_documents fad

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
3640: AND fd.usage_type = 'O'
3641: AND fd.datatype_id = 6

Line 3654: FROM fnd_attached_documents fad, fnd_documents fd

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
3656: AND fd.usage_type = 'O'
3657: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3658:

Line 3670: FROM fnd_attached_documents fad

3666: DELETE FROM fnd_documents
3667: WHERE usage_type = 'O'
3668: AND document_id IN
3669: (SELECT document_id
3670: FROM fnd_attached_documents fad
3671: WHERE fad.pk1_value = TO_CHAR(p_repair_line_id));
3672:
3673: -- delete from FND_ATTACHED_DOCUMENTS table
3674: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

Line 3673: -- delete from FND_ATTACHED_DOCUMENTS table

3669: (SELECT document_id
3670: FROM fnd_attached_documents fad
3671: WHERE fad.pk1_value = TO_CHAR(p_repair_line_id));
3672:
3673: -- delete from FND_ATTACHED_DOCUMENTS table
3674: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3675: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3676: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3677: 'Deleting from fnd_attached_documents');

Line 3677: 'Deleting from fnd_attached_documents');

3673: -- delete from FND_ATTACHED_DOCUMENTS table
3674: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3675: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3676: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3677: 'Deleting from fnd_attached_documents');
3678: END IF;
3679:
3680: DELETE FROM fnd_attached_documents fad
3681: WHERE fad.pk1_value = TO_CHAR(p_repair_line_id);

Line 3680: DELETE FROM fnd_attached_documents fad

3676: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3677: 'Deleting from fnd_attached_documents');
3678: END IF;
3679:
3680: DELETE FROM fnd_attached_documents fad
3681: WHERE fad.pk1_value = TO_CHAR(p_repair_line_id);
3682:
3683: -- Api body ends here
3684: