[Home] [Help]
547: -- 11I -- At downtime upgrade
548: -- 11IMFAR -- * At 11I Mfar transaction with Mfar adjustment being applied in R12
549: -- done in set_original_rem_amt procedure
550: -- * At extracted posting time if the adjustment is marked as 11I
551: -- we need to update this flag to retrieve Mfar distributions
552: -- Note this process is needed when application is getting posted
553: -- R12 -- At the end of nornal process
554: IF g_mode_process IN ('R12','R12_NLB','R12_11ICASH','R12_11IMFAR') THEN
555:
7576: --'REV',DECODE(NVL(adj.tax_adjusted,0),0, 'N','Y'),
7577: 'REV','Y', -- BUG 7597090
7578: 'N') -- tax_inc_flag
7579: FROM ra_ar_gt rar,
7580: ar_distributions rrc,
7581: ar_adjustments adj
7582: WHERE rar.gt_id = p_gt_id
7583: AND rar.ref_customer_trx_id = p_customer_trx_id
7584: AND rar.gp_level = 'L'
7969: --'REV',DECODE(NVL(adj.tax_adjusted,0),0, 'N','Y'),
7970: 'REV','Y', -- BUG 7597090
7971: 'N') -- tax_inc_flag
7972: FROM ra_ar_gt rar,
7973: ar_distributions rrc,
7974: ar_receivable_applications ra,
7975: ra_customer_trx_lines ctl
7976: WHERE rar.gt_id = p_gt_id
7977: AND rar.ref_customer_trx_id = p_customer_trx_id
8199: p_ae_sys_rec.set_of_books_id,
8200: p_ae_sys_rec.sob_type,
8201: rrc.tax_link_id, -- tax_link_id
8202: 'N' -- tax_inc_flag
8203: FROM ar_distributions rrc,
8204: (SELECT /*+INDEX (ra_ar_gt ra_ar_n1)*/
8205: MAX(group_id) group_id,
8206: --{HYUBPAGP
8207: MAX(source_data_key1) source_data_key1,
9705: ard.ref_customer_trx_line_id,
9706: ard.ref_account_class,
9707: ard.activity_bucket,
9708: ctl.line_type
9709: FROM ar_distributions ard,
9710: ra_customer_trx_lines ctl
9711: WHERE ctl.customer_trx_id = p_customer_trx_id
9712: AND ctl.customer_trx_line_id = ard.ref_customer_trx_line_id
9713: GROUP BY
13236: SUM( NVL(ard.acctd_amount_cr,0) - NVL(ard.acctd_amount_dr,0)) acctd_amt,
13237: ard.ref_customer_trx_line_id,
13238: ard.activity_bucket
13239: FROM ar_adjustments adj,
13240: ar_distributions ard,
13241: ra_customer_trx_lines ctl
13242: WHERE ctl.customer_trx_id = p_customer_trx_id
13243: AND ctl.line_type = 'LINE'
13244: AND adj.customer_trx_id = p_customer_trx_id
13253: SUM( NVL(ard.acctd_amount_cr,0) - NVL(ard.acctd_amount_dr,0)) acctd_amt,
13254: ard.ref_customer_trx_line_id,
13255: ard.activity_bucket
13256: FROM ar_receivable_applications ra,
13257: ar_distributions ard,
13258: ra_customer_trx_lines ctl
13259: WHERE ctl.customer_trx_id = p_customer_trx_id
13260: AND ctl.line_type = 'LINE'
13261: AND ra.applied_customer_trx_id = p_customer_trx_id
13874: from ar_adjustments adj
13875: where customer_trx_id = p_customer_trx.customer_trx_id
13876: and nvl(upgrade_method,'11I') <> 'R12' -- non R12 adjustments
13877: and exists (select 'x' -- non detailed distributions
13878: from ar_distributions
13879: where source_id = adj.adjustment_id
13880: and source_table = 'ADJ'
13881: and source_type <> 'REC'
13882: and nvl(ref_customer_trx_line_id,-1) < 0);
16973: x_exec_status OUT NOCOPY VARCHAR2)
16974: IS
16975: CURSOR c1 IS
16976: SELECT MAX(line_id)
16977: FROM ar_distributions_all;
16978: g_num NUMBER;
16979: l_rows NUMBER;
16980: BEGIN
16981: OPEN c1;