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.FV_1219_TRANSACTIONS dependencies on DUAL

Line 5075: ' FROM DUAL';

5071: to_char(l_end_date,'MM/DD/YY')||'''||'' ''||'''||
5072: to_char(SYSDATE,'MM/DD/YY')||'''||'' ''||'''||
5073: RPAD(v_do_name,20)||'''||'' ''||'''||RPAD(v_do_tel_num, 14)||
5074: RPAD(' ',10)||''''||
5075: ' FROM DUAL';
5076:
5077: v_total_line_count := v_total_line_count + 1;
5078: fv_flatfiles.create_flat_file(v_stmt);
5079:

Line 5106: FROM DUAL';

5102: replace(replace(to_char('||x_amt||',
5103: decode(sign('||x_amt||'), 1, ''0000000000000.00'', 0,
5104: ''0000000000000.00'', ''000000000000.00'')),
5105: ''.'',''''),'' '','''')|| RPAD('' '',57)
5106: FROM DUAL';
5107:
5108: v_total_line_count := v_total_line_count + 1;
5109: fv_flatfiles.create_flat_file(v_stmt);
5110: END LOOP;

Line 5126: FROM DUAL;

5122: '0000000000000.00', 0,
5123: '0000000000000.00',
5124: '000000000000.00')),'.',''),' ','')
5125: INTO l_amt
5126: FROM DUAL;
5127:
5128: --Print 210 Lines with following format
5129: --210.001 xxxxxxxxxxxxxxx xxxxxxxx
5130: v_stmt := 'SELECT ''210.''||'''||LPAD(v_rec_count,3,0)||

Line 5133: ' FROM DUAL';

5129: --210.001 xxxxxxxxxxxxxxx xxxxxxxx
5130: v_stmt := 'SELECT ''210.''||'''||LPAD(v_rec_count,3,0)||
5131: '''||'' ''||'''||
5132: l_amt||'''||'' ''||'''||line_210.alc_code||''''||
5133: ' FROM DUAL';
5134:
5135: v_total_line_count := v_total_line_count + 1;
5136: fv_flatfiles.create_flat_file(v_stmt);
5137: END LOOP;

Line 5159: FROM DUAL;

5155: '0000000000000.00', 0,
5156: '0000000000000.00',
5157: '000000000000.00')),'.',''),' ','')
5158: INTO l_amt
5159: FROM DUAL;
5160:
5161: --Print 211-420 (excl. 410) Lines with following format
5162: --211.001 xxxxxxxxxxxxxxx xxxxxxxx mm/yy
5163: v_stmt := 'SELECT '''||line_211_420.line_num||'''||'||'''.'''||'||

Line 5168: ' FROM DUAL';

5164: '''||LPAD(v_rec_count,3,0)||''''||
5165: '||'' ''||'||''''||l_amt||'''||'||''' '''||'||'''||
5166: line_211_420.alc_code||''''||
5167: '||'' ''||'||''''||line_211_420.accomplish_month||''''||
5168: ' FROM DUAL';
5169:
5170: v_total_line_count := v_total_line_count + 1;
5171: fv_flatfiles.create_flat_file(v_stmt);
5172: old_line_num := line_211_420.line_num;

Line 5205: FROM DUAL;

5201: '0000000000000.00', 0,
5202: '0000000000000.00',
5203: '000000000000.00')),'.',''),' ','')
5204: INTO l_amt
5205: FROM DUAL;
5206:
5207: SELECT rpad(nvl(substr(replace(line_1220.treasury_symbol,'-',
5208: ''),1,19),' '),19, ' ')
5209: INTO l_ts

Line 5210: FROM DUAL;

5206:
5207: SELECT rpad(nvl(substr(replace(line_1220.treasury_symbol,'-',
5208: ''),1,19),' '),19, ' ')
5209: INTO l_ts
5210: FROM DUAL;
5211:
5212: --Print 410 Lines with following format
5213: --410.001 xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxx xxx
5214: v_stmt := 'SELECT ''410.''||'''||LPAD(v_line_count,3,0)||'''

Line 5221: ' FROM DUAL';

5217: '||'' ''||''000000000000000''||'' ''||'||
5218: ''''||l_ts||'''||'||''' ''||'''||
5219: LPAD(v_entry_number,3,0)||''''||
5220: '||RPAD('' '',17)'||
5221: ' FROM DUAL';
5222:
5223: v_total_line_count := v_total_line_count + 1;
5224: fv_flatfiles.create_flat_file(v_stmt);
5225:

Line 5235: FROM DUAL;

5231: '0000000000000.00', 0,
5232: '0000000000000.00',
5233: '000000000000.00')),'.',''),' ','')
5234: INTO l_amt
5235: FROM DUAL;
5236:
5237: SELECT rpad(nvl(substr(replace(line_1220.treasury_symbol,'-',''),
5238: 1,19),' '),19, ' ')
5239: INTO l_ts

Line 5240: FROM DUAL;

5236:
5237: SELECT rpad(nvl(substr(replace(line_1220.treasury_symbol,'-',''),
5238: 1,19),' '),19, ' ')
5239: INTO l_ts
5240: FROM DUAL;
5241:
5242: --Print 410 Lines with following format
5243: --410.001 xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxx xxx
5244: v_stmt := 'SELECT ''410.''||'''||LPAD(v_line_count,3,0)||

Line 5251: ' FROM DUAL';

5247: ''''||l_amt||'''||'' '''||
5248: '||'''||l_ts||'''||'||''' ''||'''||
5249: LPAD(v_entry_number,3,0)||''''||
5250: '||RPAD('' '',17)'||
5251: ' FROM DUAL';
5252:
5253: v_total_line_count := v_total_line_count + 1;
5254: fv_flatfiles.create_flat_file(v_stmt);
5255:

Line 5266: FROM DUAL;

5262: decode(sign(line_1220.col2_amt), 1, '0000000000000.00',
5263: 0, '0000000000000.00', '000000000000.00')),
5264: '.',''),' ','')
5265: INTO l_amt
5266: FROM DUAL;
5267:
5268: SELECT replace(replace(to_char(line_1220.col3_amt,
5269: decode(sign(line_1220.col3_amt), 1, '0000000000000.00', 0,
5270: '0000000000000.00', '000000000000.00')),'.',''),' ','')

Line 5272: FROM DUAL;

5268: SELECT replace(replace(to_char(line_1220.col3_amt,
5269: decode(sign(line_1220.col3_amt), 1, '0000000000000.00', 0,
5270: '0000000000000.00', '000000000000.00')),'.',''),' ','')
5271: INTO l_amt2
5272: FROM DUAL;
5273:
5274: SELECT rpad(nvl(substr(replace(line_1220.treasury_symbol,
5275: '-',''),1,19),' '),19, ' ')
5276: INTO l_ts

Line 5277: FROM DUAL;

5273:
5274: SELECT rpad(nvl(substr(replace(line_1220.treasury_symbol,
5275: '-',''),1,19),' '),19, ' ')
5276: INTO l_ts
5277: FROM DUAL;
5278:
5279: --Print 410 Lines with following format
5280: --410.001 xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxx xxx
5281: v_stmt := 'SELECT ''410.''||'''||LPAD(v_line_count,3,0)||

Line 5288: ' FROM DUAL';

5284: '||'''||l_amt2||'''||'' '''||
5285: '||'''||l_ts||'''||'||''' ''||'''||
5286: LPAD(v_entry_number,3,0)||''''||
5287: '||RPAD('' '',17)'||
5288: ' FROM DUAL';
5289:
5290: v_total_line_count := v_total_line_count + 1;
5291: fv_flatfiles.create_flat_file(v_stmt);
5292: END IF;

Line 5303: ' FROM DUAL';

5299:
5300: v_stmt := 'SELECT ''999.999''||'' ''||LPAD('||
5301: v_total_line_count||',8,'' '')'
5302: ||'||RPAD('' '',64)'||
5303: ' FROM DUAL';
5304:
5305: fv_flatfiles.create_flat_file(v_stmt);
5306:
5307: -- For the 'Final' run of the request set, delete all records