[Home] [Help]
802: oe_system_parameters_all osp,
803: ar_cash_receipts_all cr,
804: --BUG#5201086
805: ar_cash_receipt_history_all crh,
806: ra_customer_trx_all trx
807: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
808: 'RECP_RATE_ADJUST' ) --,'RECP_REVERSE') uptake XLA transaction reversal
809: AND gt.application_id = p_application_id
810: AND gt.event_id = app.event_id
1106: oe_system_parameters_all osp,
1107: ar_cash_receipts_all cr,
1108: --BUG#5201086
1109: ar_cash_receipt_history_all crh,
1110: ra_customer_trx_all trx
1111: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
1112: 'RECP_RATE_ADJUST' ) --,'RECP_REVERSE') uptake XLA transaction reversal
1113: AND gt.application_id = p_application_id
1114: AND gt.event_id = app.event_id
1300: gl_sets_of_books sob,
1301: oe_system_parameters_all osp,
1302: ar_cash_receipts_all cr,
1303: ar_cash_receipt_history_all crh,
1304: ra_customer_trx_all trx
1305: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
1306: 'RECP_RATE_ADJUST') -- Uptake XLA trx reversal ,'RECP_REVERSE')
1307: AND gt.application_id = 222
1308: AND gt.event_id = app.event_id
1444: /* bug7311808 -vavenugo*/
1445: NVL(DIST.CURRENCY_CONVERSION_TYPE,trxf.exchange_rate_type), -- EXCHANGE_RATE_TYPE
1446: NVL(DIST.CURRENCY_CONVERSION_RATE,trxf.exchange_rate), -- EXCHANGE_RATE
1447: NVL(DIST.CURRENCY_CONVERSION_DATE, nvl(trxf.exchange_date, DECODE(dist.REF_PREV_CUST_TRX_LINE_ID, null, trxf.trx_date,
1448: nvl((select trxt.trx_date from ra_customer_trx_all trxt where trxt.customer_trx_id = trxf.previous_customer_trx_id),trxf.trx_date)))) , -- EXCHANGE_DATE
1449: /* End bug7311808 -vavenugo */ /* if REF_PREV_CUST_TRX_LINE_ID is NULL, use CM exchange_date/trx_date. Otherwise use INV exchange_date/trx_date*/
1450: NVL(dist.acctd_amount_cr,0) -
1451: NVL(dist.acctd_amount_dr,0), -- ACCTD_AMOUNT
1452: NVL(dist.taxable_accounted_cr,0) -
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,
1533: ra_cust_trx_line_gl_dist_all gldf,
1534: ar_payment_schedules_all psch
1535: WHERE gt.event_type_code IN ('CM_CREATE','CM_UPDATE' ) --BUG#3419926
1740: ar_receivable_applications_all app,
1741: ar_cash_basis_dists_all dist,
1742: gl_sets_of_books sob,
1743: oe_system_parameters_all osp,
1744: ra_customer_trx_all trxf,
1745: ra_customer_trx_lines_all tlf,
1746: ra_cust_trx_line_gl_dist_all gldf,
1747: ar_payment_schedules_all psch
1748: WHERE gt.event_type_code IN ('CM_CREATE','CM_UPDATE' )
1883: ,'' -- LOCATION_SEGMENT_ID
1884: ,sob.currency_code -- BASE_CURRENCY_CODE
1885: ,trx.exchange_rate_type -- EXCHANGE_RATE_TYPE
1886: ,trx.exchange_rate -- EXCHANGE_RATE
1887: ,DECODE(trx.previous_customer_trx_id, NULL, trx.exchange_date, (select trx_date from ra_customer_trx_all where customer_trx_id = trx.previous_customer_trx_id) ) -- EXCHANGE_DATE
1888: ,'' -- ACCTD_AMOUNT
1889: ,'' -- TAXABLE_ACCTD_AMOUNT
1890: ,trx.org_id -- ORG_ID
1891: ,'' -- HEADER_TABLE_ID
1944: ,gt.event_type_code
1945: ,gt.event_class_code
1946: ,gt.entity_code
1947: ,'N' --MFAR_ADDITIONAL_ENTRY
1948: FROM ra_customer_trx_all trx,
1949: gl_sets_of_books sob,
1950: xla_events_gt gt,
1951: ar_payment_schedules_all psch,
1952: ra_cust_trx_line_gl_dist_all ctlgd
2155: ,'N' --MFAR_ADDITIONAL_ENTRY
2156: FROM ar_adjustments_all adj,
2157: gl_sets_of_books sob,
2158: xla_events_gt gt,
2159: ra_customer_trx_all trxf,
2160: ra_cust_trx_line_gl_dist_all ctlgd
2161: WHERE gt.event_type_code = 'ADJ_CREATE'
2162: AND gt.application_id = p_application_id
2163: AND adj.adjustment_id = gt.source_id_int_1
2240: ,'N' --MFAR_ADDITIONAL_ENTRY
2241: FROM ar_adjustments_all adj,
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
2629: ,gt.entity_code
2630: ,'N' --MFAR_ADDITIONAL_ENTRY
2631: --}
2632: FROM xla_events_gt gt,
2633: ra_customer_trx_all trx,
2634: gl_sets_of_books sob
2635: WHERE gt.event_type_code IN ('BILL_CREATE' ,'BILL_UPDATE' ,'BILL_REVERSE')
2636: AND gt.application_id = p_application_id
2637: AND gt.source_id_int_1 = trx.customer_trx_id
2772: li.location_segment_id, -- LOCATION_SEGMENT_ID
2773: sob.currency_code, -- BASE_CURRENCY
2774: hd.exchange_rate_type, -- EXCHANGE_RATE_TYPE
2775: hd.exchange_rate, -- EXCHANGE_RATE
2776: DECODE(hd.previous_customer_trx_id, NULL, hd.exchange_date, (select trx_date from ra_customer_trx_all where customer_trx_id = hd.previous_customer_trx_id) ), -- EXCHANGE_DATE
2777: gld.acctd_amount, -- ACCTD_AMOUNT
2778: '', -- TAXABLE_ACCTD_AMOUNT
2779: gld.org_id, -- ORG_ID
2780: gld.customer_trx_id, -- HEADER_ID
2848: --}
2849: FROM xla_events_gt gt,
2850: ra_cust_trx_line_gl_dist_all gld,
2851: ra_customer_trx_lines_all li,
2852: ra_customer_trx_all hd,
2853: gl_sets_of_books sob,
2854: oe_system_parameters_all osp
2855: WHERE gt.event_type_code IN ('INV_CREATE' , 'INV_UPDATE' ,
2856: 'CM_CREATE' , 'CM_UPDATE' ,
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,
3071: ra_cust_trx_line_gl_dist_all gldt,
3072: oe_system_parameters_all osp
3073: WHERE gt.event_type_code = 'ADJ_CREATE'
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,
3366: ra_cust_trx_line_gl_dist_all gldt,
3367: ar_payment_schedules_all psch,
3368: ar_cash_receipts_all cr
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,
3502: ra_cust_trx_line_gl_dist_all gldt,
3503: ar_payment_schedules_all psch
3504: WHERE gt.event_type_code IN ( 'CM_CREATE','CM_UPDATE' )
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
3634: AND gt.event_id = app.event_id
3635: AND dist.source_table = 'RA'
3801: ar_receivable_applications_all app,
3802: AR_CASH_BASIS_DISTS_ALL acb,
3803: gl_sets_of_books sob,
3804: oe_system_parameters_all osp,
3805: ra_customer_trx_all trxt,
3806: ra_customer_trx_lines_all tlt,
3807: ra_cust_trx_line_gl_dist_all gldt,
3808: ar_payment_schedules_all psch,
3809: ar_system_parameters_all ars
3905: ar_receivable_applications_all app,
3906: AR_CASH_BASIS_DISTS_ALL acb,
3907: gl_sets_of_books sob,
3908: oe_system_parameters_all osp,
3909: ra_customer_trx_all trxt,
3910: ra_customer_trx_lines_all tlt,
3911: ra_cust_trx_line_gl_dist_all gldt,
3912: ar_payment_schedules_all psch,
3913: ar_system_parameters_all ars
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,
5542: event_id
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,
5924: source_id_int_1
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,
6484: gl_ledgers lg,
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,
6601: gl_ledgers lg,
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,
6714: gl_ledgers lg,
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,
6834: gl_ledgers lg,
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,
7117: ra_cust_trx_line_gl_dist_all gldt,
7118: ar_payment_schedules_all psch,
7119: ar_cash_receipts_all cr,
7619: ,tl.tax_line_id --tax_line_id
7620: ,'N'
7621: FROM xla_events_gt gt,
7622: ar_transaction_history_all th,
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,
7996: -----------------
7997: -- The table in which the posting_control_id is present in AR are:
7998: -- AR_MC_CASH_BASIS_DISTS_ALL Obsolete unified Accrual and Cash basis accounting
7999: -- AR_CASH_BASIS_DISTS_ALL Obsolete unified Accrual and Cash basis accounting
8000: -- RA_CUSTOMER_TRX_ALL Do not post
8001: -- AR_RATE_ADJUSTMENTS_ALL Do not post
8002: -- AR_CASH_RECEIPT_HISTORY_ALL A Those 4 A entities will post together
8003: -- AR_MC_CASH_RECEIPT_HIST A (Misc) Cash Receipt
8004: -- AR_MISC_CASH_DISTRIBUTIONS_ALL A