DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 262: fnd_attached_documents fad

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
266: -- Changed bug 9081077

Line 294: fnd_attached_documents fad

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
298: fad.document_id = fdv.document_id and

Line 315: fnd_attached_documents fad

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'
319: and fdv.datatype_name = 'Short Text'

Line 335: fnd_attached_documents fad

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
339: fdv.datatype_name = 'Long Text' and

Line 353: fnd_attached_documents fad

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
357: fad.pk1_value= to_char(p_org_id) and

Line 1325: fnd_attached_documents fad

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
1329: fad.entity_name ='EAM_WORK_ORDERS' and

Line 1344: fnd_attached_documents fad

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
1348: fad.entity_name ='EAM_DISCRETE_OPERATIONS'and