Hi all,
Thanks for your time!
Regards,
Use strings uaampay.fmb | egrep -i '(select|insert|update|delete)'
Gives you something like this:
select utrpycd_code, utrpycd_desc from utrpycd where utrpycd_rev_loc_id
= (select uzrcloc_rev_loc_id from uzrcloc where uzrcloc_cash_drawer_user_id = :key_block.cash_drawer_user_id)
select utvasvc_code, utvasvc_desc from utvasvc where utvasvc_desc not like 'Elec%' order by utvasvc_code
select utvresv_code, utvresv_desc from utvresv where utvresv_desc not like 'Elec%' and utvresv_desc not like 'Good%' order by utvresv_code
select '1' acci, '2' title, '3' status, '4' eff, '5' term from dual
select '1' fund, '2' title, '3' ftyp, '4' entry, '5' status, '6' eff, '7' term from dual
select '1' locn, '2' title, '3' status, '4' eff, '5' term from dual
select '1' prog, '2' title, '3' entry, '4' status, '5' eff, '6' term from dual
select '1' acct, '2' title, '3' atyp, '4' entry, '5' status, '6' eff, '7' term from dual
select '1' ccen, '2' title, '3' entry, '4' status, '5' eff, '6' term from dual
select '1' coas, '2' title, '3' status, '4' eff, '5' term from dual
select '1' rucl, '2' title, '3' type, '4' status, '5' eff, '6' term from dual
select '1' prog, '2' title, '3' entry, '4' status, '5' eff, '6' term from dual
select utrbank_code, ucbcust_last_name ||
decode(ucbcust_first_name, null , '' , ', ' ||
ucbcust_first_name) || decode(ucbcust_middle_name, null , '' , ' ' ||
ucbcust_middle_name) bank_description from utrbank, ucbcust
where ucbcust_cust_code = utrbank_cust_code_bank
select utrpycd_code, utrpycd_desc from utrpycd, utvreas where utrpycd_code = utvreas_code
and utvreas_rsnt_code = 'NUPC' and utrpycd_rev_loc_id =
(select uzrcloc_rev_loc_id from uzrcloc where uzrcloc_cash_drawer_user_id =
:key_block.cash_drawer_user_id)
select stvstat_code, stvstat_desc from stvstat order by 1
select utrpycd_code, utrpycd_desc from utrpycd where utrpycd_rev_loc_id =
(select uzrcloc_rev_loc_id from uzrcloc where uzrcloc_cash_drawer_user_id = :key_block.cash_drawer_user_id)
select utvasvc_code, utvasvc_desc from utvasvc where utvasvc_desc not like 'Elec%'
order by utvasvc_code
:key is a bind variable - bind variables start with a leading colon. Note the 'select [garbage] from dual' statements. Those do not really impact performance at all. Ignore them. Forms developers do that to avoid having to code fixed data in header for display tables. PS I edited the output a little to be more human readable.