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.PAY_CA_AMT_IN_WORDS dependencies on FND_LOOKUP_VALUES

Line 98: fnd_lookup_values flv

94: if numeral = 0 and to_number(abs_num) = 0 then
95: select description
96: into c_zero
97: from fnd_lookup_types flt,
98: fnd_lookup_values flv
99: where flt.application_id = 200
100: and flt.lookup_type = 'NUMBERS'
101: and flv.lookup_type = flt.lookup_type
102: and flv.lookup_code = '0'

Line 134: fnd_lookup_values flv9,

130: into and_lookup,
131: dollars_lookup,
132: cents_lookup
133: from fnd_lookup_types flt9,
134: fnd_lookup_values flv9,
135: fnd_lookup_types flt10,
136: fnd_lookup_values flv10,
137: fnd_lookup_types flt11,
138: fnd_lookup_values flv11

Line 136: fnd_lookup_values flv10,

132: cents_lookup
133: from fnd_lookup_types flt9,
134: fnd_lookup_values flv9,
135: fnd_lookup_types flt10,
136: fnd_lookup_values flv10,
137: fnd_lookup_types flt11,
138: fnd_lookup_values flv11
139: where flt9.application_id = 800
140: and flt9.lookup_type = 'AMOUNT_IN_WORDS'

Line 138: fnd_lookup_values flv11

134: fnd_lookup_values flv9,
135: fnd_lookup_types flt10,
136: fnd_lookup_values flv10,
137: fnd_lookup_types flt11,
138: fnd_lookup_values flv11
139: where flt9.application_id = 800
140: and flt9.lookup_type = 'AMOUNT_IN_WORDS'
141: and flv9.lookup_type = flt9.lookup_type
142: and flv9.lookup_code = 'AND'

Line 160: from fnd_lookup_values flv1,

156: select ' '||flv1.meaning||' ',
157: flv2.description
158: into c_billion,
159: billion_lookup
160: from fnd_lookup_values flv1,
161: fnd_lookup_types flt1,
162: fnd_lookup_values flv2,
163: fnd_lookup_types flt2
164: where flt1.application_id = 800

Line 162: fnd_lookup_values flv2,

158: into c_billion,
159: billion_lookup
160: from fnd_lookup_values flv1,
161: fnd_lookup_types flt1,
162: fnd_lookup_values flv2,
163: fnd_lookup_types flt2
164: where flt1.application_id = 800
165: and flt1.lookup_type = 'AMOUNT_IN_WORDS'
166: and flv1.lookup_type = flt1.lookup_type

Line 183: from fnd_lookup_values flv3,

179: select ' '||flv3.meaning||' ',
180: flv4.description
181: into c_million,
182: million_lookup
183: from fnd_lookup_values flv3,
184: fnd_lookup_types flt3,
185: fnd_lookup_values flv4,
186: fnd_lookup_types flt4
187: where flt3.application_id = 800

Line 185: fnd_lookup_values flv4,

181: into c_million,
182: million_lookup
183: from fnd_lookup_values flv3,
184: fnd_lookup_types flt3,
185: fnd_lookup_values flv4,
186: fnd_lookup_types flt4
187: where flt3.application_id = 800
188: and flt3.lookup_type = 'AMOUNT_IN_WORDS'
189: and flv3.lookup_type = flt3.lookup_type

Line 206: from fnd_lookup_values flv5,

202: select ' '||flv5.meaning||' ',
203: flv6.description
204: into c_thousand,
205: thousand_lookup
206: from fnd_lookup_values flv5,
207: fnd_lookup_types flt5,
208: fnd_lookup_values flv6,
209: fnd_lookup_types flt6
210: where flt5.application_id = 800

Line 208: fnd_lookup_values flv6,

204: into c_thousand,
205: thousand_lookup
206: from fnd_lookup_values flv5,
207: fnd_lookup_types flt5,
208: fnd_lookup_values flv6,
209: fnd_lookup_types flt6
210: where flt5.application_id = 800
211: and flt5.lookup_type = 'AMOUNT_IN_WORDS'
212: and flv5.lookup_type = flt5.lookup_type

Line 231: from fnd_lookup_values flv7,

227:
228: if units_seg <> '0' then
229: select flv7.description
230: into units_lookup
231: from fnd_lookup_values flv7,
232: fnd_lookup_types flt7
233: where flt7.application_id = 200
234: and flt7.lookup_type = 'NUMBERS'
235: and flv7.lookup_type = flt7.lookup_type