[Home] [Help]
536: -- 11I -- At downtime upgrade
537: -- 11IMFAR -- * At 11I Mfar transaction with Mfar adjustment being applied in R12
538: -- done in set_original_rem_amt procedure
539: -- * At extracted posting time if the adjustment is marked as 11I
540: -- we need to update this flag to retrieve Mfar distributions
541: -- Note this process is needed when application is getting posted
542: -- R12 -- At the end of nornal process
543: IF g_mode_process IN ('R12','R12_NLB','R12_11ICASH','R12_11IMFAR') THEN
544:
6635: --'REV',DECODE(NVL(adj.tax_adjusted,0),0, 'N','Y'),
6636: 'REV','Y', -- BUG 7597090
6637: 'N') -- tax_inc_flag
6638: FROM ra_ar_gt rar,
6639: ar_distributions rrc,
6640: ar_adjustments adj
6641: WHERE rar.gt_id = p_gt_id
6642: AND rar.ref_customer_trx_id = p_customer_trx_id
6643: AND rar.gp_level = 'L'
6862: p_ae_sys_rec.set_of_books_id,
6863: p_ae_sys_rec.sob_type,
6864: rrc.tax_link_id, -- tax_link_id
6865: 'N' -- tax_inc_flag
6866: FROM ar_distributions rrc,
6867: (SELECT /*+INDEX (ra_ar_gt ra_ar_n1)*/
6868: MAX(group_id) group_id,
6869: --{HYUBPAGP
6870: MAX(source_data_key1) source_data_key1,
8288: ard.ref_customer_trx_line_id,
8289: ard.ref_account_class,
8290: ard.activity_bucket,
8291: ctl.line_type
8292: FROM ar_distributions ard,
8293: ra_customer_trx_lines ctl
8294: WHERE ctl.customer_trx_id = p_customer_trx_id
8295: AND ctl.customer_trx_line_id = ard.ref_customer_trx_line_id
8296: GROUP BY
11768: SUM( NVL(ard.acctd_amount_cr,0) - NVL(ard.acctd_amount_dr,0)) acctd_amt,
11769: ard.ref_customer_trx_line_id,
11770: ard.activity_bucket
11771: FROM ar_adjustments adj,
11772: ar_distributions ard,
11773: ra_customer_trx_lines ctl
11774: WHERE ctl.customer_trx_id = p_customer_trx_id
11775: AND ctl.line_type = 'LINE'
11776: AND adj.customer_trx_id = p_customer_trx_id
15261: x_exec_status OUT NOCOPY VARCHAR2)
15262: IS
15263: CURSOR c1 IS
15264: SELECT MAX(line_id)
15265: FROM ar_distributions_all;
15266: g_num NUMBER;
15267: l_rows NUMBER;
15268: BEGIN
15269: OPEN c1;
15334: , LEDGER_ID
15335: , BASE_CURRENCY
15336: )
15337: SELECT
15338: ar_distributions_s.NEXTVAL -- cash_basis_distribution_id
15339: , lad.CREATED_BY -- created_by
15340: , lad.CREATION_DATE -- creation_date
15341: , lad.LAST_UPDATE_DATE -- last_update_date
15342: , lad.LAST_UPDATED_BY -- last_updated_by