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 3339: FROM fnd_attached_documents fad,

3335: fdtl.doc_attribute12 dattr12,
3336: fdtl.doc_attribute13 dattr13,
3337: fdtl.doc_attribute14 dattr14,
3338: fdtl.doc_attribute15 dattr15
3339: FROM fnd_attached_documents fad,
3340: fnd_documents fd,
3341: fnd_documents_tl fdtl
3342: WHERE fad.document_id = fd.document_id
3343: AND fd.document_id = fdtl.document_id

Line 3640: 'Inserting into fnd_attached_documents for

3636:
3637: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3638: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3639: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3640: 'Inserting into fnd_attached_documents for
3641: document id = '||docrec.document_id);
3642: END IF;
3643:
3644: -- Create attachment record

Line 3645: INSERT INTO fnd_attached_documents

3641: document id = '||docrec.document_id);
3642: END IF;
3643:
3644: -- Create attachment record
3645: INSERT INTO fnd_attached_documents
3646: (attached_document_id,
3647: document_id,
3648: creation_date,
3649: created_by,

Line 3676: fnd_attached_documents_s.NEXTVAL,

3672: attribute13, attribute14,
3673: attribute15,
3674: column1)
3675: (SELECT
3676: fnd_attached_documents_s.NEXTVAL,
3677: docrec.document_id,
3678: SYSDATE,
3679: Fnd_Global.user_id,
3680: SYSDATE,

Line 3705: FROM fnd_attached_documents

3701: docrec.attribute11, docrec.attribute12,
3702: docrec.attribute13, docrec.attribute14,
3703: docrec.attribute15,
3704: docrec.column1
3705: FROM fnd_attached_documents
3706: WHERE attached_document_id = docrec.attached_document_id);
3707:
3708: END LOOP; -- end of working through all attachments
3709:

Line 3887: fnd_attached_documents fad

3883: WHERE media_id IN
3884: (SELECT fdtl.media_id
3885: FROM fnd_documents_tl fdtl,
3886: fnd_documents fd,
3887: fnd_attached_documents fad
3888: WHERE fdtl.document_id = fd.document_id
3889: AND fd.document_id = fad.document_id
3890: AND fd.usage_type = 'O'
3891: AND fd.datatype_id = 1

Line 3906: fnd_attached_documents fad

3902: WHERE media_id IN
3903: (SELECT fdtl.media_id
3904: FROM fnd_documents_tl fdtl,
3905: fnd_documents fd,
3906: fnd_attached_documents fad
3907: WHERE fdtl.document_id = fd.document_id
3908: AND fd.document_id = fad.document_id
3909: AND fd.usage_type = 'O'
3910: AND fd.datatype_id = 2

Line 3925: fnd_attached_documents fad

3921: WHERE media_id IN
3922: (SELECT fdtl.media_id
3923: FROM fnd_documents_tl fdtl,
3924: fnd_documents fd,
3925: fnd_attached_documents fad
3926: WHERE fdtl.document_id = fd.document_id
3927: AND fd.document_id = fad.document_id
3928: AND fd.usage_type = 'O'
3929: AND fd.datatype_id IN (3,4)

Line 3945: fnd_attached_documents fad

3941: WHERE file_id IN
3942: (SELECT fdtl.media_id
3943: FROM fnd_documents_tl fdtl,
3944: fnd_documents fd,
3945: fnd_attached_documents fad
3946: WHERE fdtl.document_id = fd.document_id
3947: AND fd.document_id = fad.document_id
3948: AND fd.usage_type = 'O'
3949: AND fd.datatype_id = 6

Line 3962: FROM fnd_attached_documents fad, fnd_documents fd

3958:
3959: DELETE FROM fnd_documents_tl
3960: WHERE document_id IN
3961: (SELECT fad.document_id
3962: FROM fnd_attached_documents fad, fnd_documents fd
3963: WHERE fad.document_id = fd.document_id
3964: AND fd.usage_type = 'O'
3965: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3966:

Line 3978: FROM fnd_attached_documents fad

3974: DELETE FROM fnd_documents
3975: WHERE usage_type = 'O'
3976: AND document_id IN
3977: (SELECT document_id
3978: FROM fnd_attached_documents fad
3979: WHERE fad.pk1_value = TO_CHAR(p_repair_line_id));
3980:
3981: -- delete from FND_ATTACHED_DOCUMENTS table
3982: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

Line 3981: -- delete from FND_ATTACHED_DOCUMENTS table

3977: (SELECT document_id
3978: FROM fnd_attached_documents fad
3979: WHERE fad.pk1_value = TO_CHAR(p_repair_line_id));
3980:
3981: -- delete from FND_ATTACHED_DOCUMENTS table
3982: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3983: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3984: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3985: 'Deleting from fnd_attached_documents');

Line 3985: 'Deleting from fnd_attached_documents');

3981: -- delete from FND_ATTACHED_DOCUMENTS table
3982: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3983: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3984: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3985: 'Deleting from fnd_attached_documents');
3986: END IF;
3987:
3988: DELETE FROM fnd_attached_documents fad
3989: WHERE fad.pk1_value = TO_CHAR(p_repair_line_id);

Line 3988: DELETE FROM fnd_attached_documents fad

3984: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3985: 'Deleting from fnd_attached_documents');
3986: END IF;
3987:
3988: DELETE FROM fnd_attached_documents fad
3989: WHERE fad.pk1_value = TO_CHAR(p_repair_line_id);
3990:
3991: -- Api body ends here
3992: