DBA Data[Home] [Help]

APPS.IEU_UWQ_TASK_INFO_PKG dependencies on FND_LOOKUPS

Line 57: FROM jtf_notes_b b, jtf_notes_tl tl, jtf_note_contexts c, fnd_lookups fnd_status,

53: b.last_update_login ,tl.notes ,
54: b.entered_by ,b.entered_date ,b.source_object_id ,b.source_object_code ,
55: c.note_context_type_id ,c.note_context_type ,b.note_status ,fnd_status.meaning ,
56: res.source_name ,b.note_type ,fnd_type.meaning note_type_meaning
57: FROM jtf_notes_b b, jtf_notes_tl tl, jtf_note_contexts c, fnd_lookups fnd_status,
58: fnd_lookups fnd_type, jtf_rs_resource_extns res
59: WHERE b.jtf_note_id = tl.jtf_note_id and tl.language = userenv('LANG')
60: and b.jtf_note_id = c.jtf_note_id and b.note_type = fnd_type.lookup_code(+)
61: and fnd_type.lookup_type(+) = 'JTF_NOTE_TYPE'

Line 58: fnd_lookups fnd_type, jtf_rs_resource_extns res

54: b.entered_by ,b.entered_date ,b.source_object_id ,b.source_object_code ,
55: c.note_context_type_id ,c.note_context_type ,b.note_status ,fnd_status.meaning ,
56: res.source_name ,b.note_type ,fnd_type.meaning note_type_meaning
57: FROM jtf_notes_b b, jtf_notes_tl tl, jtf_note_contexts c, fnd_lookups fnd_status,
58: fnd_lookups fnd_type, jtf_rs_resource_extns res
59: WHERE b.jtf_note_id = tl.jtf_note_id and tl.language = userenv('LANG')
60: and b.jtf_note_id = c.jtf_note_id and b.note_type = fnd_type.lookup_code(+)
61: and fnd_type.lookup_type(+) = 'JTF_NOTE_TYPE'
62: and b.note_status = fnd_status.lookup_code(+)

Line 83: FROM jtf_notes_b b, jtf_notes_tl tl, jtf_note_contexts c, fnd_lookups fnd_status,

79: b.last_update_login ,tl.notes ,
80: b.entered_by ,b.entered_date ,b.source_object_id ,b.source_object_code ,
81: c.note_context_type_id ,c.note_context_type ,b.note_status ,fnd_status.meaning ,
82: res.source_name ,b.note_type ,fnd_type.meaning note_type_meaning
83: FROM jtf_notes_b b, jtf_notes_tl tl, jtf_note_contexts c, fnd_lookups fnd_status,
84: fnd_lookups fnd_type, jtf_rs_resource_extns res
85: WHERE b.jtf_note_id = tl.jtf_note_id and tl.language = userenv('LANG')
86: and b.jtf_note_id = c.jtf_note_id and b.note_type = fnd_type.lookup_code(+)
87: and fnd_type.lookup_type(+) = 'JTF_NOTE_TYPE'

Line 84: fnd_lookups fnd_type, jtf_rs_resource_extns res

80: b.entered_by ,b.entered_date ,b.source_object_id ,b.source_object_code ,
81: c.note_context_type_id ,c.note_context_type ,b.note_status ,fnd_status.meaning ,
82: res.source_name ,b.note_type ,fnd_type.meaning note_type_meaning
83: FROM jtf_notes_b b, jtf_notes_tl tl, jtf_note_contexts c, fnd_lookups fnd_status,
84: fnd_lookups fnd_type, jtf_rs_resource_extns res
85: WHERE b.jtf_note_id = tl.jtf_note_id and tl.language = userenv('LANG')
86: and b.jtf_note_id = c.jtf_note_id and b.note_type = fnd_type.lookup_code(+)
87: and fnd_type.lookup_type(+) = 'JTF_NOTE_TYPE'
88: and b.note_status = fnd_status.lookup_code(+)

Line 113: FROM jtf_notes_b b, jtf_notes_tl tl, jtf_note_contexts c, fnd_lookups fnd_status,

109: b.last_update_login ,tl.notes ,
110: b.entered_by ,b.entered_date ,b.source_object_id ,b.source_object_code ,
111: c.note_context_type_id ,c.note_context_type ,b.note_status ,fnd_status.meaning ,
112: res.source_name ,b.note_type ,fnd_type.meaning note_type_meaning
113: FROM jtf_notes_b b, jtf_notes_tl tl, jtf_note_contexts c, fnd_lookups fnd_status,
114: fnd_lookups fnd_type, jtf_rs_resource_extns res
115: WHERE b.jtf_note_id = tl.jtf_note_id and tl.language = userenv('LANG')
116: and b.jtf_note_id = c.jtf_note_id and b.note_type = fnd_type.lookup_code(+)
117: and fnd_type.lookup_type(+) = 'JTF_NOTE_TYPE'

Line 114: fnd_lookups fnd_type, jtf_rs_resource_extns res

110: b.entered_by ,b.entered_date ,b.source_object_id ,b.source_object_code ,
111: c.note_context_type_id ,c.note_context_type ,b.note_status ,fnd_status.meaning ,
112: res.source_name ,b.note_type ,fnd_type.meaning note_type_meaning
113: FROM jtf_notes_b b, jtf_notes_tl tl, jtf_note_contexts c, fnd_lookups fnd_status,
114: fnd_lookups fnd_type, jtf_rs_resource_extns res
115: WHERE b.jtf_note_id = tl.jtf_note_id and tl.language = userenv('LANG')
116: and b.jtf_note_id = c.jtf_note_id and b.note_type = fnd_type.lookup_code(+)
117: and fnd_type.lookup_type(+) = 'JTF_NOTE_TYPE'
118: and b.note_status = fnd_status.lookup_code(+)