DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on FND_DOCUMENTS_LONG_TEXT

Line 278: FND_DOCUMENTS_LONG_TEXT fdlt,

274: fad.seq_num as "ALONGSEQNUM"
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

Line 317: FND_DOCUMENTS_LONG_TEXT fdlt,

313: fdv.description as "OPALONGWORKDESC",
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

Line 1066: FND_DOCUMENTS_LONG_TEXT fdlt,

1062: if p_select=1 then
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

Line 1083: FND_DOCUMENTS_LONG_TEXT fdlt,

1079: else
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