DBA Data[Home] [Help]

APPS.QPR_DEAL_ETL dependencies on DUAL

Line 1348: (select rownum num from dual connect by level <=3)

1344: '3', p_rbt_oad_val)/l.ordered_qty) er_val,
1345: decode(nvl(l.ordered_qty, 0), 0 , 0, decode(num, '1', p_sm_oad_val, '2', p_pt_oad_val,
1346: '3', p_rbt_oad_val)) er_tot_val
1347: from qpr_pn_int_lines l,
1348: (select rownum num from dual connect by level <=3)
1349: where l.source_ref_hdr_id = p_source_ref_hdr_id
1350: and l.source_ref_line_id = p_source_ref_line_id
1351: and l.source_id = p_src_id)
1352: where er_name is not null;