eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_TRX_PVT dependencies on FUN_DIST_LINES

Line 117: from fun_dist_lines

113: l_diff_amount NUMBER;
114: BEGIN
115: select sum(amount_cr), sum(amount_dr)
116: into l_sum_amount_cr, l_sum_amount_dr
117: from fun_dist_lines
118: where trx_id = p_trx_id
119: and dist_type_flag = 'L'
120: and party_type_flag = 'I';
121:

Line 124: update fun_dist_lines dist1

120: and party_type_flag = 'I';
121:
122: IF l_sum_amount_cr is not null and l_sum_amount_cr <> 0 THEN
123: l_diff_amount := p_init_amount_dr - l_sum_amount_cr ;
124: update fun_dist_lines dist1
125: set dist1.amount_cr = dist1.amount_cr + l_diff_amount
126: where dist1.amount_cr = (select max(dist2.amount_cr) from fun_dist_lines dist2
127: where dist2.dist_type_flag = 'L'
128: and dist2.party_type_flag = 'I'

Line 126: where dist1.amount_cr = (select max(dist2.amount_cr) from fun_dist_lines dist2

122: IF l_sum_amount_cr is not null and l_sum_amount_cr <> 0 THEN
123: l_diff_amount := p_init_amount_dr - l_sum_amount_cr ;
124: update fun_dist_lines dist1
125: set dist1.amount_cr = dist1.amount_cr + l_diff_amount
126: where dist1.amount_cr = (select max(dist2.amount_cr) from fun_dist_lines dist2
127: where dist2.dist_type_flag = 'L'
128: and dist2.party_type_flag = 'I'
129: and dist2.trx_id = p_trx_id)
130: and rownum = 1

Line 137: update fun_dist_lines dist1

133: and dist1.trx_id = p_trx_id;
134: END IF;
135: IF l_sum_amount_dr is not null and l_sum_amount_dr <> 0 THEN
136: l_diff_amount := p_init_amount_cr - l_sum_amount_dr;
137: update fun_dist_lines dist1
138: set dist1.amount_dr = dist1.amount_dr + l_diff_amount
139: where dist1.amount_dr = (select max(dist2.amount_dr) from fun_dist_lines dist2
140: where dist2.dist_type_flag = 'L'
141: and dist2.party_type_flag = 'I'

Line 139: where dist1.amount_dr = (select max(dist2.amount_dr) from fun_dist_lines dist2

135: IF l_sum_amount_dr is not null and l_sum_amount_dr <> 0 THEN
136: l_diff_amount := p_init_amount_cr - l_sum_amount_dr;
137: update fun_dist_lines dist1
138: set dist1.amount_dr = dist1.amount_dr + l_diff_amount
139: where dist1.amount_dr = (select max(dist2.amount_dr) from fun_dist_lines dist2
140: where dist2.dist_type_flag = 'L'
141: and dist2.party_type_flag = 'I'
142: and dist2.trx_id = p_trx_id)
143: and rownum = 1

Line 2753: INSERT INTO fun_dist_lines(DIST_ID,

2749: WHERE headers.batch_id = l_reversed_batch_id
2750: AND headers.original_trx_id = lines.trx_id;
2751:
2752: -- Insert into dist_lines
2753: INSERT INTO fun_dist_lines(DIST_ID,
2754: LINE_ID,
2755: DIST_NUMBER,
2756: PARTY_ID,
2757: PARTY_TYPE_FLAG,

Line 2787: SELECT fun_dist_lines_s.nextval,

2783: LAST_UPDATED_BY,
2784: LAST_UPDATE_DATE,
2785: LAST_UPDATE_LOGIN,
2786: trx_id)
2787: SELECT fun_dist_lines_s.nextval,
2788: reversed_lines.LINE_ID,
2789: orig_dists.DIST_NUMBER,
2790: orig_dists.PARTY_ID,
2791: orig_dists.PARTY_TYPE_FLAG,

Line 2827: fun_dist_lines orig_dists

2823: FROM fun_trx_headers reversed_hdrs,
2824: fun_trx_lines reversed_lines,
2825: --fun_batch_dists reversed_b_dists,
2826: fun_trx_lines orig_lines,
2827: fun_dist_lines orig_dists
2828: WHERE reversed_hdrs.batch_id = l_reversed_batch_id
2829: AND reversed_hdrs.trx_id = reversed_lines.trx_id
2830: AND reversed_hdrs.original_trx_id = orig_lines.trx_id
2831: AND orig_lines.line_id = orig_dists.line_id

Line 3261: INSERT INTO fun_dist_lines(DIST_ID,

3257: WHERE headers.batch_id = l_reversed_batch_id
3258: AND headers.original_trx_id = lines.trx_id;
3259:
3260: -- Insert into dist_lines
3261: INSERT INTO fun_dist_lines(DIST_ID,
3262: LINE_ID,
3263: DIST_NUMBER,
3264: PARTY_ID,
3265: PARTY_TYPE_FLAG,

Line 3295: SELECT fun_dist_lines_s.nextval,

3291: LAST_UPDATED_BY,
3292: LAST_UPDATE_DATE,
3293: LAST_UPDATE_LOGIN,
3294: trx_id)
3295: SELECT fun_dist_lines_s.nextval,
3296: reversed_lines.LINE_ID,
3297: orig_dists.DIST_NUMBER,
3298: orig_dists.PARTY_ID,
3299: orig_dists.PARTY_TYPE_FLAG,

Line 3335: fun_dist_lines orig_dists

3331: FROM fun_trx_headers reversed_hdrs,
3332: fun_trx_lines reversed_lines,
3333: --fun_batch_dists reversed_b_dists,
3334: fun_trx_lines orig_lines,
3335: fun_dist_lines orig_dists
3336: WHERE reversed_hdrs.batch_id = l_reversed_batch_id
3337: AND reversed_hdrs.trx_id = reversed_lines.trx_id
3338: AND reversed_hdrs.original_trx_id = orig_lines.trx_id
3339: AND orig_lines.line_id = orig_dists.line_id

Line 4272: fun_dist_lines dists

4268: dists.ccid,
4269: hdrs.trx_number
4270: FROM fun_trx_headers hdrs,
4271: fun_trx_lines lines,
4272: fun_dist_lines dists
4273: WHERE hdrs.batch_id = p_batch_id
4274: AND hdrs.trx_id = lines.trx_id
4275: AND lines.line_id = dists.line_id
4276: AND dists.party_type_flag = 'I'

Line 4374: DELETE FROM fun_dist_lines

4370:
4371: -- Delete the distributions generated for the initiator
4372: IF p_trx_tbl.COUNT > 0 THEN
4373: FOR i IN p_trx_tbl.first..p_trx_tbl.last LOOP
4374: DELETE FROM fun_dist_lines
4375: WHERE party_type_flag = 'I'
4376: AND dist_type_flag = 'L'
4377: --AND auto_generate_flag = 'Y'
4378: AND line_id IN

Line 4416: INSERT INTO fun_dist_lines(DIST_ID,

4412: LOOP
4413: l_amount_cr := ROUND(((p_init_dist_tbl(i).amount_cr * p_trx_tbl(t).init_amount_dr)/l_total)/ l_mau ) * l_mau;
4414: l_amount_dr := ROUND(((p_init_dist_tbl(i).amount_dr * p_trx_tbl(t).init_amount_cr)/l_total)/ l_mau ) * l_mau;
4415:
4416: INSERT INTO fun_dist_lines(DIST_ID,
4417: LINE_ID,
4418: DIST_NUMBER,
4419: PARTY_ID,
4420: PARTY_TYPE_FLAG,

Line 4434: VALUES (fun_dist_lines_s.nextval,

4430: LAST_UPDATED_BY,
4431: LAST_UPDATE_DATE,
4432: LAST_UPDATE_LOGIN,
4433: trx_id)
4434: VALUES (fun_dist_lines_s.nextval,
4435: l_line_id,
4436: i,
4437: p_trx_tbl(t).initiator_id,
4438: 'I',