SELECT iu.instd_unit_id, iu.fk_cust_id, bill_cd,
iu.mfg_prod_cd, iu.mfg_prod_seq_no, ccequip.fk_mkt_cd,
eff_tmstmp, cust_ord_id, ord_dt, iu.xnac_co_cd,
iu.xnac_div_cd, smmr_wvr_cd, warr_expn_dt,
iu.auto_replen_ind, iu.ms_stat_cd,
inst_dist_id, instn_dt, iu.last_auto_dt,
iu.replen_freq_vlu, cpc_pln_cd, std_sply_ind,
emcv_total_qty, tot_actl_cpy_qty, init_emcv_tot_qty, ms_tran_cd,
ord_typ_cd, cap_doc_tran_cd, xeep_cust_no, cms_contr_no,
mthly_emcv_pct, iu.last_upd_dt,
iu.last_upd_src_id, fsma_bill_code, old_mfg_prod_cd,
old_mfg_prod_seq_no, auto_rpln_stat_cd, rpln_stat_chng_dt,
prod_retro_cd, dist_cd_serv, serv_rep_id, invc_pllg_id,
poolg_typ_cd, iu.fk_cust_id, ' ', ccstat.ms_stat_cd_desc,
get_cancel_dt (iu.ms_stat_cd, eff_tmstmp),
ccgroup.soc_id, mtr_read_reqd_ind1, msq_eff_dt,
mtr_read_reqd_ind2, mtr_read_reqd_ind3, mtr_read_reqd_ind4,
mtr_read_reqd_ind5, mtr_read_reqd_ind6, mtr_read_reqd_ind7,
mtr_read_reqd_ind8, iu.sbi,
ccequip.metered_ind,
get_meter_desc (
iu.mfg_prod_cd,
1,
iu.instd_unit_id,
iu.ms_stat_cd
),
get_meter_desc (
iu.mfg_prod_cd,
2,
iu.instd_unit_id,
iu.ms_stat_cd
),
get_meter_desc (
iu.mfg_prod_cd,
3,
iu.instd_unit_id,
iu.ms_stat_cd
),
get_meter_desc (
iu.mfg_prod_cd,
4,
iu.instd_unit_id,
iu.ms_stat_cd
),
get_meter_desc (
iu.mfg_prod_cd,
5,
iu.instd_unit_id,
iu.ms_stat_cd
),
get_meter_desc (
iu.mfg_prod_cd,
6,
iu.instd_unit_id,
iu.ms_stat_cd
),
get_meter_desc (
iu.mfg_prod_cd,
7,
iu.instd_unit_id,
iu.ms_stat_cd
),
get_meter_desc (
iu.mfg_prod_cd,
8,
iu.instd_unit_id,
iu.ms_stat_cd
),
ccstat.group_code,
ccstat.fk_ms_stat_cd,
iu.xbs_ops_br_no_info,
iu.xbs_contr_id,
iu.org_unit_cd,
iu.xbs_ind,
decode(et. mfg_prod_cd,'','N','Y'),
get_mtr_rd_multiplier(iu.mfg_prod_cd,1),
get_mtr_rd_multiplier(iu.mfg_prod_cd,2),
get_mtr_rd_multiplier(iu.mfg_prod_cd,3),
get_mtr_rd_multiplier(iu.mfg_prod_cd,4),
get_mtr_rd_multiplier(iu.mfg_prod_cd,5),
get_mtr_rd_multiplier(iu.mfg_prod_cd,6),
get_mtr_rd_multiplier(iu.mfg_prod_cd,7),
get_mtr_rd_multiplier(iu.mfg_prod_cd,8),
iu.asr_ind
FROM installed_unit iu,
complete_call_ms_stat_desc ccstat,
complete_call_equipment ccequip,
complete_call_grouping ccgroup,
emax_table172 et
WHERE ccequip.fk_complete_call_id = 785841
AND iu.fk_cust_id = ccequip.fk_cust_id
AND iu.instd_unit_id = ccequip.instd_unit_id
AND iu.ms_stat_cd = ccstat.fk_ms_stat_cd
AND ccequip.fk_complete_call_id = ccgroup.fk_complete_call_id
AND ccequip.fk_cust_id = ccgroup.fk_cust_id
AND ccequip.display =to_char('Y')
AND iu.mfg_prod_cd = et.mfg_prod_cd (+)
AND iu.mfg_prod_seq_no = et.mfg_prod_seq_no (+)
ORDER BY sort_asc1,
sort_desc1 DESC,
sort_asc2,
sort_desc2 DESC,
sort_asc3,
sort_desc3 DESC,
sort_asc4,
sort_desc4 DESC,
sort_asc5,
sort_desc5 DESC,
ccstat.group_code,
ccstat.fk_ms_stat_cd,
ccgroup.soc_id,
cust_typ_ind,
ccgroup.fk_cust_id,
iu.mfg_prod_cd,
iu.mfg_prod_seq_no;
] 
Blog
Search
Help
Members
Register
Login
Home
