DBA Data[Home] [Help]

APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on AR_DISTRIBUTIONS_ALL

Line 422: ar_distributions_all a

418: ABS(b.from_acctd_amount) ELSE NULL END
419: ,b.activity_bucket
420: ,b.line_id
421: FROM ar_line_app_detail_gt b,
422: ar_distributions_all a
423: WHERE b.line_id = a.line_id;
424:
425: l_from_amount_dr DBMS_SQL.NUMBER_TABLE;
426: l_from_amount_cr DBMS_SQL.NUMBER_TABLE;

Line 457: UPDATE ar_distributions_all a

453: EXIT;
454: END IF;
455:
456: FORALL i IN l_line_id.FIRST .. l_line_id.LAST
457: UPDATE ar_distributions_all a
458: SET a.from_amount_dr = l_from_amount_dr(i),
459: a.from_amount_cr = l_from_amount_cr(i),
460: a.from_acctd_amount_dr = l_from_acctd_amount_dr(i),
461: a.from_acctd_amount_cr = l_from_acctd_amount_cr(i),

Line 551: ar_distributions_all dist,

547: NVL(dist.AMOUNT_CR,0)-NVL(dist.AMOUNT_DR,0),
548: NVL(dist.ACCTD_AMOUNT_CR,0)-NVL(dist.ACCTD_AMOUNT_DR,0)
549: FROM xla_events_gt eve,
550: ar_receivable_applications_all app,
551: ar_distributions_all dist,
552: gl_ledgers sob
553: WHERE eve.application_id = 222
554: AND eve.entity_code IN ('RECEIPTS','TRANSACTIONS')
555: AND eve.event_id = app.event_id

Line 800: ar_distributions_all dist,

796: ,'N' --MFAR_ADDITIONAL_ENTRY
797: ,nvl(dist.ref_mf_dist_flag,'N') --REF_MF_DIST_FLAG
798: FROM xla_events_gt gt,
799: ar_receivable_applications_all app,
800: ar_distributions_all dist,
801: gl_sets_of_books sob,
802: oe_system_parameters_all osp,
803: ar_cash_receipts_all cr,
804: --BUG#5201086

Line 1104: ar_distributions_all dist,

1100: ,gt.entity_code
1101: ,'N' --MFAR_ADDITIONAL_ENTRY
1102: FROM xla_events_gt gt,
1103: ar_receivable_applications_all app,
1104: ar_distributions_all dist,
1105: gl_sets_of_books sob,
1106: oe_system_parameters_all osp,
1107: ar_cash_receipts_all cr,
1108: --BUG#5201086

Line 1528: ar_distributions_all dist,

1524: , dist.REF_PREV_CUST_TRX_LINE_ID -- 9860123
1525: , the_segment_value(sob.chart_of_accounts_id, 'GL_BALANCING', dist.ref_dist_ccid)
1526: FROM xla_events_gt gt,
1527: ar_receivable_applications_all app,
1528: ar_distributions_all dist,
1529: gl_sets_of_books sob,
1530: oe_system_parameters_all osp,
1531: ra_customer_trx_all trxf,
1532: ra_customer_trx_lines_all tlf,

Line 2246: ar_distributions_all ard

2242: gl_sets_of_books sob,
2243: xla_events_gt gt,
2244: ra_customer_trx_all trxf,
2245: ar_transaction_history_all trh,
2246: ar_distributions_all ard
2247: WHERE gt.event_type_code = 'ADJ_CREATE'
2248: AND gt.application_id = p_application_id
2249: AND adj.adjustment_id = gt.source_id_int_1
2250: AND adj.set_of_books_id = sob.set_of_books_id

Line 3066: ar_distributions_all dist,

3062: ,'N' --MFAR_ADDITIONAL_ENTRY
3063: ,decode(trxt.upgrade_method,'R12_11ICASH','N','')
3064: --}
3065: FROM xla_events_gt gt,
3066: ar_distributions_all dist,
3067: ar_adjustments_all adj,
3068: gl_sets_of_books sob,
3069: ra_customer_trx_all trxt,
3070: ra_customer_trx_lines_all tlt,

Line 3361: ar_distributions_all dist,

3357: , NULL
3358: ,decode(trxt.upgrade_method,'R12_11ICASH','N','')
3359: FROM xla_events_gt gt,
3360: ar_receivable_applications_all app,
3361: ar_distributions_all dist,
3362: gl_sets_of_books sob,
3363: oe_system_parameters_all osp,
3364: ra_customer_trx_all trxt,
3365: ra_customer_trx_lines_all tlt,

Line 3497: ar_distributions_all dist,

3493: ,the_segment_value(sob.chart_of_accounts_id, 'GL_BALANCING', dist.ref_dist_ccid)
3494: ,decode(trxt.upgrade_method,'R12_11ICASH','N','')
3495: FROM xla_events_gt gt,
3496: ar_receivable_applications_all app,
3497: ar_distributions_all dist,
3498: gl_sets_of_books sob,
3499: oe_system_parameters_all osp,
3500: ra_customer_trx_all trxt,
3501: ra_customer_trx_lines_all tlt,

Line 3629: ar_distributions_all dist,

3625: , NULL
3626: , NULL
3627: FROM xla_events_gt gt,
3628: ar_receivable_applications_all app,
3629: ar_distributions_all dist,
3630: gl_sets_of_books sob,
3631: ra_customer_trx_all trx
3632: WHERE gt.event_type_code IN ( 'CM_CREATE','CM_UPDATE' )
3633: AND gt.application_id = p_application_id

Line 4125: ar_distributions_all dist, --ar_distributions_all dist,

4121: --}
4122: ,'N' --MFAR_ADDITIONAL_ENTRY
4123: FROM xla_events_gt gt,
4124: ar_receivable_applications_all app,
4125: ar_distributions_all dist, --ar_distributions_all dist,
4126: gl_sets_of_books sob
4127: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
4128: 'RECP_RATE_ADJUST' ) --Uptake XLA reversal,'RECP_REVERSE')
4129: -- Exclude 'RECP_REVERSE' for no extract at line level is reuired for Reversal

Line 4334: ar_distributions_all dist,

4330: --}
4331: FROM xla_events_gt gt,
4332: ar_cash_receipts_all cr,
4333: ar_cash_receipt_history_all crh,
4334: ar_distributions_all dist,
4335: gl_sets_of_books sob,
4336: ar_cash_receipt_history_all pcrh
4337: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
4338: 'MISC_RECP_CREATE' ,'MISC_RECP_UPDATE' ,

Line 4534: ar_distributions_all dist,

4530: FROM xla_events_gt gt,
4531: ar_cash_receipts_all cr,
4532: ar_cash_receipt_history_all crh,
4533: ar_receivable_applications_all app,
4534: ar_distributions_all dist,
4535: gl_sets_of_books sob
4536: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
4537: 'RECP_RATE_ADJUST' ) --Uptake XLA Reversal,'RECP_REVERSE' )
4538: AND gt.application_id = p_application_id

Line 5153: AR_DISTRIBUTIONS_ALL ard

5149: AND MFAR_ADDITIONAL_ENTRY = 'N'
5150: GROUP BY event_id, source_id, CM_APP_TO_TRX_LINE_ID
5151: HAVING sum(ACCTD_AMOUNT) <> 0 AND sum(AMOUNT) = 0
5152: ) curr,
5153: AR_DISTRIBUTIONS_ALL ard
5154: WHERE l.MFAR_ADDITIONAL_ENTRY = 'N'
5155: AND l.FROM_TO_FLAG = 'T'
5156: AND l.LEVEL_FLAG = 'L'
5157: AND l.event_id = curr.event_id

Line 5384: AR_DISTRIBUTIONS_ALL ard,

5380: ,l.THIRD_PARTY_SITE_ID
5381: ,l.THIRD_PARTY_TYPE
5382: ,ard.source_type
5383: FROM AR_XLA_LINES_EXTRACT l,
5384: AR_DISTRIBUTIONS_ALL ard,
5385: (select event_id,
5386: source_id,
5387: LINE_ID,
5388: sum(-1*ACCTD_AMOUNT) CURR_ROUND_ACCTD_AMT

Line 5466: ,ar_distributions_all ard

5462: ,ard.currency_code --currency_code
5463: ,ra.org_id --org_id
5464: ,sob.currency_code --base currency code
5465: FROM ar_receivable_applications_all ra
5466: ,ar_distributions_all ard
5467: ,(SELECT entity_id,
5468: source_id_int_1,
5469: event_id,
5470: ledger_id

Line 5537: ,ar_distributions_all ard

5533: ,ct.sold_to_site_use_id --sold_to_site_use_id
5534: ,ct.ship_to_customer_id --ship_to_customer_id
5535: ,ct.ship_to_site_use_id --ship_to_site_use_id
5536: FROM ar_receivable_applications_all ra
5537: ,ar_distributions_all ard
5538: ,ra_customer_trx_all ct
5539: ,ra_customer_trx_lines_all ctl
5540: ,(SELECT entity_id,
5541: source_id_int_1,

Line 5919: ,ar_distributions_all ard

5915: ,decode(ct.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
5916: FROM ar_cash_receipt_history_all crh
5917: ,ar_cash_receipts_all cr
5918: ,ar_receivable_applications_all ra
5919: ,ar_distributions_all ard
5920: ,ra_customer_trx_all ct
5921: ,ra_cust_trx_line_gl_dist_all ctlgd
5922: ,ra_customer_trx_lines_all ctl
5923: ,(SELECT entity_id,

Line 6042: ar_distributions_all ard,

6038: ,'CASH'), 'ACTUAL','REVERSAL') DIST_LINE_STATUS
6039: FROM xla_events_gt gt,
6040: ar_cash_receipt_history_all crh,
6041: ar_cash_receipts_all cr,
6042: ar_distributions_all ard,
6043: gl_ledgers lg
6044: WHERE gt.application_id = 222
6045: AND gt.event_type_code IN ('RECP_CREATE','RECP_UPDATE','MISC_RECP_CREATE','MISC_RECP_UPDATE','RECP_RATE_ADJUST')
6046: AND gt.event_id = crh.event_id

Line 6108: ar_distributions_all ard,

6104: , decode(state.status, 'ORG_DIST','ACTUAL','REVERSAL') DIST_LINE_STATUS
6105: FROM xla_events_gt gt,
6106: ar_cash_receipt_history_all crh,
6107: ar_cash_receipts_all cr,
6108: ar_distributions_all ard,
6109: ar_cash_receipt_history_all paircrh,
6110: ar_distributions_all pairard,
6111: gl_ledgers lg,
6112: (SELECT 'ORG_DIST' AS status FROM DUAL UNION

Line 6110: ar_distributions_all pairard,

6106: ar_cash_receipt_history_all crh,
6107: ar_cash_receipts_all cr,
6108: ar_distributions_all ard,
6109: ar_cash_receipt_history_all paircrh,
6110: ar_distributions_all pairard,
6111: gl_ledgers lg,
6112: (SELECT 'ORG_DIST' AS status FROM DUAL UNION
6113: SELECT 'REV_DIST' AS status FROM DUAL) state
6114: WHERE gt.application_id = 222

Line 6173: ar_distributions_all ard,

6169: , decode(state.status, 'ORG_DIST','ACTUAL','REVERSAL') DIST_LINE_STATUS
6170: FROM xla_events_gt gt,
6171: ar_cash_receipt_history_all crh,
6172: ar_cash_receipts_all cr,
6173: ar_distributions_all ard,
6174: ar_cash_receipt_history_all paircrh,
6175: ar_distributions_all pairard,
6176: gl_ledgers lg,
6177: (SELECT 'ORG_DIST' AS status FROM DUAL UNION

Line 6175: ar_distributions_all pairard,

6171: ar_cash_receipt_history_all crh,
6172: ar_cash_receipts_all cr,
6173: ar_distributions_all ard,
6174: ar_cash_receipt_history_all paircrh,
6175: ar_distributions_all pairard,
6176: gl_ledgers lg,
6177: (SELECT 'ORG_DIST' AS status FROM DUAL UNION
6178: SELECT 'REV_DIST' AS status FROM DUAL) state
6179: WHERE gt.application_id = 222

Line 6384: | Description : Builds the MFAR distributions all the application distributions

6380: END;
6381:
6382: /*-------------------------------------------------------------------------------+
6383: | Procedure Name : mfar_get_ra
6384: | Description : Builds the MFAR distributions all the application distributions
6385: | when the corresponding CRH distributions are already posted
6386: | to GL or when the application distributions belong to a different
6387: | event than that of their corresponding CRH distributions.
6388: | Calls the procedure to insert into the extract after building

Line 6479: ar_distributions_all ard,

6475: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
6476: FROM xla_events_gt gt,
6477: ar_receivable_applications_all ra,
6478: ar_cash_receipt_history_all crh,
6479: ar_distributions_all ard,
6480: ra_customer_trx_all trx,
6481: ra_cust_trx_line_gl_dist_all ctlgd,
6482: ra_customer_trx_lines_all ctl,
6483: ar_cash_receipts_all cr,

Line 6596: ar_distributions_all ard,

6592: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
6593: FROM xla_events_gt gt,
6594: ar_receivable_applications_all ra,
6595: ar_cash_receipt_history_all crh,
6596: ar_distributions_all ard,
6597: ra_customer_trx_all trx,
6598: ra_cust_trx_line_gl_dist_all ctlgd,
6599: ra_customer_trx_lines_all ctl,
6600: ar_cash_receipts_all cr,

Line 6709: ar_distributions_all ard,

6705: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
6706: FROM xla_events_gt gt,
6707: ar_receivable_applications_all ra,
6708: ar_cash_receipt_history_all crh,
6709: ar_distributions_all ard,
6710: ra_customer_trx_all trx,
6711: ra_cust_trx_line_gl_dist_all ctlgd,
6712: ra_customer_trx_lines_all ctl,
6713: ar_cash_receipts_all cr,

Line 6829: ar_distributions_all ard,

6825: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
6826: FROM xla_events_gt gt,
6827: ar_receivable_applications_all ra,
6828: ar_cash_receipt_history_all crh,
6829: ar_distributions_all ard,
6830: ra_customer_trx_all trx,
6831: ra_cust_trx_line_gl_dist_all ctlgd,
6832: ra_customer_trx_lines_all ctl,
6833: ar_cash_receipts_all cr,

Line 7112: ar_distributions_all dist,

7108: , currard.code_combination_id
7109: , dist.ref_dist_ccid
7110: FROM xla_events_gt gt,
7111: ar_receivable_applications_all app,
7112: ar_distributions_all dist,
7113: gl_sets_of_books sob,
7114: oe_system_parameters_all osp,
7115: ra_customer_trx_all trxt,
7116: ra_customer_trx_lines_all tlt,

Line 7120: ar_distributions_all currard

7116: ra_customer_trx_lines_all tlt,
7117: ra_cust_trx_line_gl_dist_all gldt,
7118: ar_payment_schedules_all psch,
7119: ar_cash_receipts_all cr,
7120: ar_distributions_all currard
7121: WHERE gt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE', 'RECP_RATE_ADJUST' )
7122: AND gt.application_id = 222
7123: AND gt.event_id = app.event_id
7124: AND (app.upgrade_method IN ('R12_NLB','R12', 'R12_11IMFAR', 'R12_11ICASH','11I_R12_POST','R12_MERGE')

Line 7259: ,ar_distributions_all ard

7255: ,cr.amount
7256: FROM ar_cash_receipts_all cr
7257: ,ar_misc_cash_distributions_all mcd
7258: ,ar_cash_receipt_history_all crh
7259: ,ar_distributions_all ard
7260: ,(SELECT entity_id,
7261: source_id_int_1
7262: FROM xla_events_gt
7263: WHERE application_id = 222

Line 7627: ar_distributions_all dist,

7623: ra_customer_trx_all trx,
7624: ra_customer_trx_lines_all tl,
7625: ra_cust_trx_line_gl_dist_all gld,
7626: oe_system_parameters_all osp,
7627: ar_distributions_all dist,
7628: gl_sets_of_books sob,
7629: ar_payment_schedules_all psch
7630: WHERE gt.event_type_code IN ('BILL_CREATE' ,
7631: 'BILL_UPDATE' ,

Line 7830: ar_distributions_all dist,

7826: ,DECODE(gt.event_type_code,'MISC_RECP_REVERSE' ,'Y','N') --reversal_code
7827: ,'N'
7828: FROM xla_events_gt gt,
7829: ar_misc_cash_distributions_all mcd,
7830: ar_distributions_all dist,
7831: gl_sets_of_books sob,
7832: ar_cash_receipts_all cr,
7833: --5201086
7834: ar_cash_receipt_history_all crh

Line 9185: from ar_distributions_all ard

9181: IF ( g_glr_ccid_cache_tab.EXISTS(p_ra_id) = FALSE ) THEN
9182:
9183: select ard.code_combination_id
9184: into l_ccid
9185: from ar_distributions_all ard
9186: where ard.source_table = 'RA'
9187: and ard.source_type = p_gain_loss_identifier
9188: and ard.source_id = p_ra_id;
9189: -- bug 7694448 modified select to fetch ccid based on whether it is gain or loss