DBA Data[Home] [Help]

APPS.FUN_TRX_PVT dependencies on FUN_BATCH_DISTS

Line 2523: INSERT INTO fun_batch_dists(BATCH_DIST_ID,

2519: WHERE hdrs2.original_trx_id = hdrs1.trx_id)
2520: WHERE hdrs1.batch_id = p_batch_id;
2521:
2522: -- Insert into init_dist
2523: INSERT INTO fun_batch_dists(BATCH_DIST_ID,
2524: LINE_NUMBER,
2525: BATCH_ID,
2526: CCID,
2527: AMOUNT_CR,

Line 2549: FROM fun_batch_dists dist

2545: sysdate,
2546: fnd_global.user_id,
2547: sysdate,
2548: fnd_global.user_id
2549: FROM fun_batch_dists dist
2550: WHERE dist.batch_id = p_batch_id;
2551:
2552: -- Insert into trx_lines
2553: INSERT INTO fun_trx_lines(LINE_ID,

Line 2662: --fun_batch_dists reversed_b_dists,

2658: fnd_global.user_id,
2659: reversed_hdrs.trx_id
2660: FROM fun_trx_headers reversed_hdrs,
2661: fun_trx_lines reversed_lines,
2662: --fun_batch_dists reversed_b_dists,
2663: fun_trx_lines orig_lines,
2664: fun_dist_lines orig_dists
2665: WHERE reversed_hdrs.batch_id = l_reversed_batch_id
2666: AND reversed_hdrs.trx_id = reversed_lines.trx_id

Line 3113: --fun_batch_dists reversed_b_dists,

3109: fnd_global.user_id,
3110: reversed_hdrs.trx_id
3111: FROM fun_trx_headers reversed_hdrs,
3112: fun_trx_lines reversed_lines,
3113: --fun_batch_dists reversed_b_dists,
3114: fun_trx_lines orig_lines,
3115: fun_dist_lines orig_dists
3116: WHERE reversed_hdrs.batch_id = l_reversed_batch_id
3117: AND reversed_hdrs.trx_id = reversed_lines.trx_id

Line 3968: FROM fun_batch_dists

3964: ccid,
3965: amount_cr,
3966: amount_dr,
3967: description
3968: FROM fun_batch_dists
3969: WHERE batch_id = p_batch_id;
3970:
3971: l_dist_lines_tbl DIST_LINE_TBL_TYPE;
3972: CURSOR l_dist_lines_cursor IS SELECT dists.dist_id,