DBA Data[Home] [Help]

APPS.ITG_X_UTILS dependencies on FND_DOCUMENTS_SHORT_TEXT

Line 403: v_text fnd_documents_short_text.short_text%TYPE;

399: FUNCTION getAttachments(p_table_name VARCHAR2,
400: p_type VARCHAR2,
401: p_id NUMBER
402: ) RETURN VARCHAR2 AS
403: v_text fnd_documents_short_text.short_text%TYPE;
404: CURSOR cur_short_text IS
405: SELECT short.short_text FROM
406: fnd_attached_documents fad,
407: fnd_documents_vl fdv,

Line 410: fnd_documents_short_text short

406: fnd_attached_documents fad,
407: fnd_documents_vl fdv,
408: fnd_document_entities fde,
409: fnd_document_categories_vl fdcv,
410: fnd_documents_short_text short
411: WHERE
412: fad.document_id = fdv.document_id AND
413: short.media_id = fdv.media_id AND
414: fad.entity_name = fde.entity_name AND

Line 453: fnd_documents_short_text short

449: fnd_attached_documents fad,
450: fnd_documents_vl fdv,
451: fnd_document_entities fde,
452: fnd_document_categories_vl fdcv,
453: fnd_documents_short_text short
454: WHERE
455: fad.document_id = fdv.document_id AND
456: short.media_id = fdv.media_id AND
457: fad.entity_name = fde.entity_name AND