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.FND_ATTACHED_DOCUMENTS2_PKG dependencies on FND_DOCUMENTS_TL

Line 38: FROM fnd_documents_tl fdtl,

34: -- doing this in a loop to reduce amount of code
35: DELETE FROM fnd_documents_short_text
36: WHERE media_id IN
37: (SELECT fd.media_id
38: FROM fnd_documents_tl fdtl,
39: fnd_documents fd,
40: fnd_attached_documents fad
41: WHERE fdtl.document_id = fd.document_id
42: AND fd.document_id = fad.document_id

Line 52: FROM fnd_documents_tl fdtl,

48:
49: DELETE FROM fnd_documents_long_text
50: WHERE media_id IN
51: (SELECT fd.media_id
52: FROM fnd_documents_tl fdtl,
53: fnd_documents fd,
54: fnd_attached_documents fad
55: WHERE fdtl.document_id = fd.document_id
56: AND fd.document_id = fad.document_id

Line 65: FROM fnd_documents_tl fdtl,

61:
62: DELETE FROM fnd_documents_long_raw
63: WHERE media_id IN
64: (SELECT fd.media_id
65: FROM fnd_documents_tl fdtl,
66: fnd_documents fd,
67: fnd_attached_documents fad
68: WHERE fdtl.document_id = fd.document_id
69: AND fd.document_id = fad.document_id

Line 78: FROM fnd_documents_tl fdtl,

74:
75: DELETE FROM fnd_lobs
76: WHERE file_id IN
77: (SELECT fd.media_id
78: FROM fnd_documents_tl fdtl,
79: fnd_documents fd,
80: fnd_attached_documents fad
81: WHERE fdtl.document_id = fd.document_id
82: AND fd.document_id = fad.document_id

Line 88: -- Delete from FND_DOCUMENTS_TL table

84: AND fd.datatype_id = 6
85: AND fad.entity_name = X_entity_name
86: AND fad.pk1_value = X_pk1_value);
87:
88: -- Delete from FND_DOCUMENTS_TL table
89: DELETE FROM fnd_documents_tl
90: WHERE document_id IN
91: (SELECT fad.document_id
92: FROM fnd_attached_documents fad, fnd_documents fd

Line 89: DELETE FROM fnd_documents_tl

85: AND fad.entity_name = X_entity_name
86: AND fad.pk1_value = X_pk1_value);
87:
88: -- Delete from FND_DOCUMENTS_TL table
89: DELETE FROM fnd_documents_tl
90: WHERE document_id IN
91: (SELECT fad.document_id
92: FROM fnd_attached_documents fad, fnd_documents fd
93: WHERE fad.document_id = fd.document_id

Line 121: FROM fnd_documents_tl fdtl,

117: -- doing this in a loop to reduce amount of code
118: DELETE FROM fnd_documents_short_text
119: WHERE media_id IN
120: (SELECT fd.media_id
121: FROM fnd_documents_tl fdtl,
122: fnd_documents fd,
123: fnd_attached_documents fad
124: WHERE fdtl.document_id = fd.document_id
125: AND fd.document_id = fad.document_id

Line 136: FROM fnd_documents_tl fdtl,

132:
133: DELETE FROM fnd_documents_long_text
134: WHERE media_id IN
135: (SELECT fd.media_id
136: FROM fnd_documents_tl fdtl,
137: fnd_documents fd,
138: fnd_attached_documents fad
139: WHERE fdtl.document_id = fd.document_id
140: AND fd.document_id = fad.document_id

Line 150: FROM fnd_documents_tl fdtl,

146:
147: DELETE FROM fnd_documents_long_raw
148: WHERE media_id IN
149: (SELECT fd.media_id
150: FROM fnd_documents_tl fdtl,
151: fnd_documents fd,
152: fnd_attached_documents fad
153: WHERE fdtl.document_id = fd.document_id
154: AND fd.document_id = fad.document_id

Line 164: FROM fnd_documents_tl fdtl,

160:
161: DELETE FROM fnd_lobs
162: WHERE file_id IN
163: (SELECT fd.media_id
164: FROM fnd_documents_tl fdtl,
165: fnd_documents fd,
166: fnd_attached_documents fad
167: WHERE fdtl.document_id = fd.document_id
168: AND fd.document_id = fad.document_id

Line 175: -- Delete from FND_DOCUMENTS_TL table

171: AND fad.entity_name = X_entity_name
172: AND fad.pk1_value = X_pk1_value
173: AND fad.pk2_value = X_pk2_value);
174:
175: -- Delete from FND_DOCUMENTS_TL table
176: DELETE FROM fnd_documents_tl
177: WHERE document_id IN
178: (SELECT fad.document_id
179: FROM fnd_attached_documents fad, fnd_documents fd

Line 176: DELETE FROM fnd_documents_tl

172: AND fad.pk1_value = X_pk1_value
173: AND fad.pk2_value = X_pk2_value);
174:
175: -- Delete from FND_DOCUMENTS_TL table
176: DELETE FROM fnd_documents_tl
177: WHERE document_id IN
178: (SELECT fad.document_id
179: FROM fnd_attached_documents fad, fnd_documents fd
180: WHERE fad.document_id = fd.document_id

Line 211: FROM fnd_documents_tl fdtl,

207: -- doing this in a loop to reduce amount of code
208: DELETE FROM fnd_documents_short_text
209: WHERE media_id IN
210: (SELECT fd.media_id
211: FROM fnd_documents_tl fdtl,
212: fnd_documents fd,
213: fnd_attached_documents fad
214: WHERE fdtl.document_id = fd.document_id
215: AND fd.document_id = fad.document_id

Line 227: FROM fnd_documents_tl fdtl,

223:
224: DELETE FROM fnd_documents_long_text
225: WHERE media_id IN
226: (SELECT fd.media_id
227: FROM fnd_documents_tl fdtl,
228: fnd_documents fd,
229: fnd_attached_documents fad
230: WHERE fdtl.document_id = fd.document_id
231: AND fd.document_id = fad.document_id

Line 242: FROM fnd_documents_tl fdtl,

238:
239: DELETE FROM fnd_documents_long_raw
240: WHERE media_id IN
241: (SELECT fd.media_id
242: FROM fnd_documents_tl fdtl,
243: fnd_documents fd,
244: fnd_attached_documents fad
245: WHERE fdtl.document_id = fd.document_id
246: AND fd.document_id = fad.document_id

Line 257: FROM fnd_documents_tl fdtl,

253:
254: DELETE FROM fnd_lobs
255: WHERE file_id IN
256: (SELECT fd.media_id
257: FROM fnd_documents_tl fdtl,
258: fnd_documents fd,
259: fnd_attached_documents fad
260: WHERE fdtl.document_id = fd.document_id
261: AND fd.document_id = fad.document_id

Line 269: -- Delete from FND_DOCUMENTS_TL table

265: AND fad.pk1_value = X_pk1_value
266: AND fad.pk2_value = X_pk2_value
267: AND fad.pk3_value = X_pk3_value);
268:
269: -- Delete from FND_DOCUMENTS_TL table
270: DELETE FROM fnd_documents_tl
271: WHERE document_id IN
272: (SELECT fad.document_id
273: FROM fnd_attached_documents fad, fnd_documents fd

Line 270: DELETE FROM fnd_documents_tl

266: AND fad.pk2_value = X_pk2_value
267: AND fad.pk3_value = X_pk3_value);
268:
269: -- Delete from FND_DOCUMENTS_TL table
270: DELETE FROM fnd_documents_tl
271: WHERE document_id IN
272: (SELECT fad.document_id
273: FROM fnd_attached_documents fad, fnd_documents fd
274: WHERE fad.document_id = fd.document_id

Line 308: FROM fnd_documents_tl fdtl,

304: -- doing this in a loop to reduce amount of code
305: DELETE FROM fnd_documents_short_text
306: WHERE media_id IN
307: (SELECT fd.media_id
308: FROM fnd_documents_tl fdtl,
309: fnd_documents fd,
310: fnd_attached_documents fad
311: WHERE fdtl.document_id = fd.document_id
312: AND fd.document_id = fad.document_id

Line 328: FROM fnd_documents_tl fdtl,

324:
325: DELETE FROM fnd_documents_long_text
326: WHERE media_id IN
327: (SELECT fd.media_id
328: FROM fnd_documents_tl fdtl,
329: fnd_documents fd,
330: fnd_attached_documents fad
331: WHERE fdtl.document_id = fd.document_id
332: AND fd.document_id = fad.document_id

Line 347: FROM fnd_documents_tl fdtl,

343:
344: DELETE FROM fnd_documents_long_raw
345: WHERE media_id IN
346: (SELECT fd.media_id
347: FROM fnd_documents_tl fdtl,
348: fnd_documents fd,
349: fnd_attached_documents fad
350: WHERE fdtl.document_id = fd.document_id
351: AND fd.document_id = fad.document_id

Line 366: FROM fnd_documents_tl fdtl,

362:
363: DELETE FROM fnd_lobs
364: WHERE file_id IN
365: (SELECT fd.media_id
366: FROM fnd_documents_tl fdtl,
367: fnd_documents fd,
368: fnd_attached_documents fad
369: WHERE fdtl.document_id = fd.document_id
370: AND fd.document_id = fad.document_id

Line 382: -- Delete from FND_DOCUMENTS_TL table

378: AND fad.pk4_value = X_pk4_value
379: OR X_pk5_value IS NULL
380: AND fad.pk5_value = X_pk5_value);
381:
382: -- Delete from FND_DOCUMENTS_TL table
383: -- BUG#5060588 added Parens around OR's.
384: DELETE FROM fnd_documents_tl
385: WHERE document_id IN
386: (SELECT fad.document_id

Line 384: DELETE FROM fnd_documents_tl

380: AND fad.pk5_value = X_pk5_value);
381:
382: -- Delete from FND_DOCUMENTS_TL table
383: -- BUG#5060588 added Parens around OR's.
384: DELETE FROM fnd_documents_tl
385: WHERE document_id IN
386: (SELECT fad.document_id
387: FROM fnd_attached_documents fad, fnd_documents fd
388: WHERE fad.document_id = fd.document_id

Line 481: fnd_documents_tl fdtl

477: fdtl.doc_attribute13 dattr13, fdtl.doc_attribute14 dattr14,
478: fdtl.doc_attribute15 dattr15, fd.url, fdtl.title
479: FROM fnd_attached_documents fad,
480: fnd_documents fd,
481: fnd_documents_tl fdtl
482: WHERE fad.document_id = fd.document_id
483: AND fd.document_id = fdtl.document_id
484: AND fdtl.language = userenv('LANG')
485: AND fad.entity_name = X_from_entity_name

Line 518: fnd_documents_tl fdtl

514: fdtl.doc_attribute13 dattr13, fdtl.doc_attribute14 dattr14,
515: fdtl.doc_attribute15 dattr15, fd.url, fdtl.title
516: FROM fnd_attached_documents fad,
517: fnd_documents fd,
518: fnd_documents_tl fdtl
519: WHERE fad.document_id = fd.document_id
520: AND fd.document_id = fdtl.document_id
521: AND fdtl.language = userenv('LANG')
522: AND fad.entity_name = X_from_entity_name

Line 558: fnd_documents_tl fdtl

554: fdtl.doc_attribute13 dattr13, fdtl.doc_attribute14 dattr14,
555: fdtl.doc_attribute15 dattr15, fd.url, fdtl.title
556: FROM fnd_attached_documents fad,
557: fnd_documents fd,
558: fnd_documents_tl fdtl
559: WHERE fad.document_id = fd.document_id
560: AND fd.document_id = fdtl.document_id
561: AND fdtl.language = userenv('LANG')
562: AND fad.entity_name = X_from_entity_name

Line 599: fnd_documents_tl fdtl

595: fdtl.doc_attribute13 dattr13, fdtl.doc_attribute14 dattr14,
596: fdtl.doc_attribute15 dattr15, fd.url, fdtl.title
597: FROM fnd_attached_documents fad,
598: fnd_documents fd,
599: fnd_documents_tl fdtl
600: WHERE fad.document_id = fd.document_id
601: AND fd.document_id = fdtl.document_id
602: AND fdtl.language = userenv('LANG')
603: AND fad.entity_name = X_from_entity_name