Conversion From Fmt to Fmb Create ros.log file

From: Nagaraj <nagubhat_at_gmail.com>
Date: 12 Mar 2006 23:40:58 -0800
Message-ID: <1142235658.291735.119530@j33g2000cwa.googlegroups.com>

Suppose u convert ur form i..e your_form.fmb to fmt file i.e. your_form.fmt file
where there inside the fmb files there is a record group which has the following code

select /*+ INDEX(TGEW_SRVHDR PK_TGEW_SRVHDR) */ srvl_dwd_doc_no col1, srvh_suppl_type col2, srvh_suppl_code col3 from tgew_srvhdr, tgew_srvline, mgew_document where srvh_comp_code = srvl_comp_code

and srvh_sys_code = srvl_sys_code
and srvh_subsys_code = srvl_subsys_code
and srvh_brch_code = srvl_brch_code
and srvh_doc_type = srvl_doc_type
and srvh_yyyymm = srvl_yyyymm
and srvh_doc_no = srvl_doc_no
and srvh_comp_code = :blk_control.comp_code
and srvh_sys_code = :blk_control.sys_code
and srvh_status = 'Z'

and nvl(srvh_fa_crt_flg,'N') != 'Y'

and srvl_comp_code = doc_comp_code
and srvl_sys_code = doc_sys_code
and srvl_subsys_code = doc_subsys_code
and srvl_brch_code = doc_brch_code
and srvl_dwd_doc_type = doc_code

and doc_grp_flg = 50
union

select /*+ INDEX(TGEW_SRVHDR PK_TGEW_SRVHDR) */
to_char(inwl_dwd_doc_no), srvh_suppl_type, srvh_suppl_code
from tgew_srvhdr, tgew_srvline, tgew_inward_hdr, tgew_inward_line,

mgew_document
where srvh_comp_code = srvl_comp_code

and srvh_sys_code = srvl_sys_code
and srvh_subsys_code = srvl_subsys_code
and srvh_brch_code = srvl_brch_code
and srvh_doc_type = srvl_doc_type
and srvh_yyyymm = srvl_yyyymm
and srvh_doc_no = srvl_doc_no
and srvh_comp_code = :blk_control.comp_code
and srvh_sys_code = :blk_control.sys_code
and srvh_status = 'Z'

and nvl(srvh_fa_crt_flg,'N') != 'Y'

and inwh_comp_code = inwl_comp_code
and inwh_sys_code = inwl_sys_code
and inwh_subsys_code = inwl_subsys_code
and inwh_brch_code = inwl_brch_code
and inwh_doc_type = inwl_doc_type
and inwh_yyyymm = inwl_yyyymm
and inwh_doc_no = inwl_doc_no
and inwh_comp_code = srvh_comp_code
and inwh_sys_code = srvh_sys_code
and inwh_subsys_code = srvh_subsys_code
and inwh_brch_code = srvh_brch_code
and inwh_status = 'Z'
and srvl_dwd_doc_type = inwh_doc_type
and srvl_dwd_doc_no = inwh_doc_no
and inwl_comp_code = doc_comp_code
and inwl_sys_code = doc_sys_code
and inwl_subsys_code = doc_subsys_code
and inwl_brch_code = doc_brch_code
and inwl_dwd_doc_type = doc_code

and doc_grp_flg = 50
order by 1

now when u convert back from the fmt to fmb this records group is cut in half i.e. as per below

select /*+ INDEX(TGEW_SRVHDR PK_TGEW_SRVHDR) */ srvl_dwd_doc_no col1, srvh_suppl_type col2, srvh_suppl_code col3 from tgew_srvhdr, tgew_srvline, mgew_document where srvh_comp_code = srvl_comp_code

and srvh_sys_code = srvl_sys_code
and srvh_subsys_code = srvl_subsys_code
and srvh_brch_code = srvl_brch_code
and srvh_doc_type = srvl_doc_type
and srvh_yyyymm = srvl_yyyymm
and srvh_doc_no = srvl_doc_no
and srvh_comp_code = :blk_control.comp_code
and srvh_sys_code = :blk_control.sys_code
and srvh_status = 'Z'

and nvl(srvh_fa_crt_flg,'N') != 'Y'

and srvl_comp_code = doc_comp_code
and srvl_sys_code = doc_sys_code
and srvl_subsys_code = doc_subsys_code
and srvl_brch_code = doc_brch_code
and srvl_dwd_doc_type = doc_code

and doc_grp_flg = 50
union

select /*+ INDEX(TGEW_SRVHDR PK_TGEW_SRVHDR) */
to_char(inwl_dwd_doc_no), srvh_suppl_type, srvh_suppl_code
from tgew_srvhdr, tgew_srvline, tgew_inward_hdr, tgew_inward_line,

mgew_document
where srvh_comp_code = srvl_comp_code

and srvh_sys_code = srvl_sys_code
and srvh_subsys_code = srvl_subsys_code
and srvh_brch_code = srvl_brch_code
and srvh_doc_type = srvl_doc_type
and srvh_yyyymm = srvl_yyyymm
and srvh_doc_no = srvl_doc_no
and srvh_comp_code = :blk_control.comp_code
and srvh_sys_code = :blk_control.sys_code
and srvh_status = 'Z'

and nvl(srvh_fa_crt_flg,'N') != 'Y'

and inwh_comp_code = inwl_comp_code
and inwh_sys_code = inwl_sys_code
and inwh_subsys_code = inwl_subsys_code
and inwh_brch_code = inwl_brch_code
and inwh_doc_type = inwl_doc_type
and inwh_yyyymm = inwl_yyyymm
and inwh_doc_no = inwl_doc_no
and inwh_comp_code = srvh_comp_code
and inwh_sys_code = srvh_sys_code
and inwh_subsys_code = srvh_subsys_code
and inwh_brch_code = srvh_brch_code
and inwh_status = 'Z'
and srvl_dwd_doc_type = inwh_doc_type
and srvl_dwd_doc_no = inwh_doc_no
and inwl_comp_code = doc_comp_code
and inwl_sys_code = doc_sys_code
and inwl_subsys_code = doc_subsys_code
and inwl_brch_code = doc_brch_code
and inwl_dwd_doc_type = doc_code

and doc_

How to solve this problem, please answer,

Regards
Nagaraj Received on Mon Mar 13 2006 - 01:40:58 CST