DBA Data[Home] [Help]

APPS.FUN_TRX_PVT dependencies on FUN_BATCH_DISTS

Line 2685: INSERT INTO fun_batch_dists(BATCH_DIST_ID,

2681: WHERE hdrs2.original_trx_id = hdrs1.trx_id)
2682: WHERE hdrs1.batch_id = p_batch_id;
2683:
2684: -- Insert into init_dist
2685: INSERT INTO fun_batch_dists(BATCH_DIST_ID,
2686: LINE_NUMBER,
2687: BATCH_ID,
2688: CCID,
2689: AMOUNT_CR,

Line 2711: FROM fun_batch_dists dist

2707: sysdate,
2708: fnd_global.user_id,
2709: sysdate,
2710: fnd_global.user_id
2711: FROM fun_batch_dists dist
2712: WHERE dist.batch_id = p_batch_id;
2713:
2714:
2715: -- Insert into trx_lines

Line 2825: --fun_batch_dists reversed_b_dists,

2821: fnd_global.user_id,
2822: reversed_hdrs.trx_id
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

Line 3333: --fun_batch_dists reversed_b_dists,

3329: fnd_global.user_id,
3330: reversed_hdrs.trx_id
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

Line 4254: FROM fun_batch_dists

4250: ccid,
4251: amount_cr,
4252: amount_dr,
4253: description
4254: FROM fun_batch_dists
4255: WHERE batch_id = p_batch_id;
4256:
4257: l_dist_lines_tbl DIST_LINE_TBL_TYPE;
4258: CURSOR l_dist_lines_cursor IS SELECT dists.dist_id,