DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on GL_ROW_MULTIPLIERS

Line 284: select multiplier a from gl_row_multipliers

280: lead(ct, 22) over (order by a) c22,
281: sum(ct) over (order by a rows between 1 following and 22 following) c23
282: from (
283: select x.a, nvl(y.ct, 0) ct from (
284: select multiplier a from gl_row_multipliers
285: where rownum < 24) x, (
286: select a, count(*) ct from (
287: select /*+ full(sg) parallel(sg) */ nvl2(e.int_row_id,
288: 1, nvl2(NVL(rel.relationship_id,hzint.BATCH_ID),decode(sg.action_flag, 'I', 2, 3),24)) a