[Home] [Help]
265: te.entity_id ENTITY_ID
266: FROM
267: ra_customer_trx_all ct,
268: ra_cust_trx_line_gl_dist_all ctlgd,
269: xla_upgrade_dates gps,
270: ar_system_parameters_all sys,
271: ra_cust_trx_types_all tty,
272: ra_cust_trx_line_gl_dist_all ctlgd1,
273: xla_transaction_entities_upg te
370: tty.name CAT_CODE ,
371: te.entity_id ENTITY_ID
372: FROM ra_customer_trx_all ct,
373: ar_receivable_applications_all app,
374: xla_upgrade_dates gps,
375: ar_system_parameters_all sys,
376: ra_cust_trx_types_all tty,
377: ra_cust_trx_line_gl_dist_all ctlgd,
378: xla_transaction_entities_upg te
722: 1 ln_order
723: from
724: ra_customer_trx_all ct,
725: ra_cust_trx_line_gl_dist_all ctlgd,
726: xla_upgrade_dates gps,
727: xla_transaction_entities_upg ent,
728: xla_events ev,
729: xla_ae_headers hdr,
730: ra_customer_trx_lines_all ctl
778: hdr.ledger_id ledger_id,
779: 2 ln_order
780: from ra_customer_trx_all ct,
781: ar_receivable_applications_all app,
782: xla_upgrade_dates gps,
783: xla_transaction_entities_upg ent,
784: xla_events ev,
785: xla_ae_headers hdr,
786: ar_distributions_all ard
1113: tty.name CAT_CODE ,
1114: te.entity_id ENTITY_ID
1115: FROM ra_customer_trx_all ct,
1116: ar_transaction_history_all trh,
1117: xla_upgrade_dates gps,
1118: ar_transaction_history_all trh1,
1119: ar_system_parameters_all sys,
1120: ra_cust_trx_types_all tty,
1121: xla_transaction_entities_upg te
1431: hdr.ledger_id ledger_id,
1432: 1 ln_order
1433: from ra_customer_trx_all ct,
1434: ar_transaction_history_all trh,
1435: xla_upgrade_dates gps,
1436: xla_transaction_entities_upg ent,
1437: xla_events ev,
1438: xla_ae_headers hdr,
1439: ar_distributions_all ard
1782: te.entity_id ENTITY_ID
1783: FROM ar_cash_receipts_all cr,
1784: --ar_system_parameters_all sys,
1785: ar_cash_receipt_history_all crh,
1786: xla_upgrade_dates gps,
1787: ar_receipt_methods rmth,
1788: ar_cash_receipt_history_all crh1,
1789: xla_transaction_entities_upg te
1790: WHERE cr.rowid >= l_start_rowid
1885: te.entity_id ENTITY_ID
1886: FROM ar_cash_receipts_all cr,
1887: --ar_system_parameters_all sys,
1888: ar_misc_cash_distributions_all mcd,
1889: xla_upgrade_dates gps,
1890: ar_receipt_methods rmth,
1891: ar_cash_receipt_history_all crh,
1892: xla_transaction_entities_upg te
1893: WHERE cr.rowid >= l_start_rowid
1985: te.entity_id ENTITY_ID
1986: FROM ar_cash_receipts_all cr,
1987: --ar_system_parameters_all sys,
1988: ar_receivable_applications_all app,
1989: xla_upgrade_dates gps,
1990: ar_cash_receipt_history_all crh,
1991: ar_cash_receipt_history_all crh1,
1992: ar_receipt_methods rmth,
1993: xla_transaction_entities_upg te
2297: hdr.ledger_id ledger_id,
2298: 1 ln_order
2299: from ar_cash_receipts_all cr,
2300: ar_cash_receipt_history_all crh,
2301: xla_upgrade_dates gps,
2302: ar_cash_receipt_history_all crh1,
2303: xla_transaction_entities_upg ent,
2304: xla_events ev,
2305: xla_ae_headers hdr,
2393: 2 ln_order
2394: from ar_cash_receipts_all cr,
2395: ar_system_parameters_all sys,
2396: ar_receivable_applications_all app,
2397: xla_upgrade_dates gps,
2398: xla_transaction_entities_upg ent,
2399: ar_cash_receipt_history_all crh,
2400: ar_cash_receipt_history_all crh1,
2401: xla_events ev,
2470: hdr.ledger_id ledger_id,
2471: 1 ln_order
2472: from ar_cash_receipts_all cr,
2473: ar_misc_cash_distributions_all mcd,
2474: xla_upgrade_dates gps,
2475: ar_cash_receipt_history_all crh,
2476: xla_transaction_entities_upg ent,
2477: xla_events ev,
2478: xla_ae_headers hdr,
2786: adj.doc_sequence_value DOC_SEQ_VAL ,
2787: tty.name CAT_CODE ,
2788: te.entity_id ENTITY_ID
2789: FROM ar_adjustments_all adj,
2790: xla_upgrade_dates gps,
2791: ar_system_parameters_all sys,
2792: ra_customer_trx_all ct,
2793: ra_cust_trx_types_all tty,
2794: xla_transaction_entities_upg te
3050: hdr.accounting_date accounting_date,
3051: hdr.ledger_id ledger_id,
3052: 1 ln_order
3053: from ar_adjustments_all adj,
3054: xla_upgrade_dates gps,
3055: xla_transaction_entities_upg ent,
3056: xla_events ev,
3057: xla_ae_headers hdr,
3058: ar_distributions_all ard
3156: insert into ar120gir_periods(period_name)
3157: select
3158: distinct period_name
3159: from gl_periods p
3160: where start_date >= (select min(start_date) from XLA_UPGRADE_DATES)
3161: and end_date <= (select max(end_date) from XLA_UPGRADE_DATES);
3162: EXCEPTION
3163: WHEN NO_DATA_FOUND THEN
3164: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_XLA_UPGRADE.update_gl_sla_link');
3157: select
3158: distinct period_name
3159: from gl_periods p
3160: where start_date >= (select min(start_date) from XLA_UPGRADE_DATES)
3161: and end_date <= (select max(end_date) from XLA_UPGRADE_DATES);
3162: EXCEPTION
3163: WHEN NO_DATA_FOUND THEN
3164: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_XLA_UPGRADE.update_gl_sla_link');
3165: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: Insert into ar120gir_periods');
3197: FROM dual
3198: WHERE exists (SELECT 1
3199: FROM ar_system_parameters_all
3200: WHERE accounting_method = 'CASH'
3201: and set_of_books_id in (select ledger_id from xla_upgrade_dates)
3202: );
3203:
3204:
3205: exception
3221: ar_cash_receipts_all cr,
3222: ar_system_parameters_all asp,
3223: xla_distribution_links xdl,
3224: ar_cash_receipt_history_all crh,
3225: xla_upgrade_dates gps,
3226: ar_distributions_all ard,
3227: gl_je_lines gjl
3228: where xte.source_id_int_1 = cr.cash_receipt_id
3229: AND xah.accounting_date BETWEEN GPS.START_DATE AND GPS.END_DATE
3272: ar_cash_receipts_all cr,
3273: ar_system_parameters_all asp,
3274: xla_distribution_links xdl,
3275: ar_receivable_applications_all unapp,
3276: xla_upgrade_dates gps,
3277: ar_distributions_all ard,
3278: gl_je_lines gjl
3279: where xte.source_id_int_1 = cr.cash_receipt_id
3280: AND xah.accounting_date BETWEEN GPS.START_DATE AND GPS.END_DATE
3329: */
3330: LN.GL_SL_LINK_ID, 'XLAJEL'
3331: FROM GL_JE_HEADERS GHD,
3332: GL_JE_LINES GLD,
3333: XLA_UPGRADE_DATES GPS,
3334: XLA_DISTRIBUTION_LINKS LNK,
3335: XLA_AE_LINES LN
3336: WHERE EXISTS
3337: (select /*+ PUSH_SUBQ */ null
3383: */
3384: LN.GL_SL_LINK_ID, 'XLAJEL'
3385: FROM GL_JE_HEADERS GHD,
3386: GL_JE_LINES GLD,
3387: XLA_UPGRADE_DATES GPS,
3388: XLA_DISTRIBUTION_LINKS LNK,
3389: XLA_AE_LINES LN
3390: WHERE EXISTS
3391: (select /*+ PUSH_SUBQ */ null
3730: 1 ln_order,
3731: nvl((select max(ae_line_num) from xla_ae_lines ael
3732: where ael.ae_header_id=hdr.ae_header_id and application_id=222),1000) max_line_num
3733: from ar_receivable_applications_all app,
3734: xla_upgrade_dates gps,
3735: xla_transaction_entities_upg ent,
3736: ra_customer_trx_all ctcm,
3737: ar_cash_receipt_history_all crh1,
3738: ar_cash_receipt_history_all crh,
4059: te.entity_id ENTITY_ID
4060: FROM ar_cash_receipts_all cr,
4061: --ar_system_parameters_all sys,
4062: ar_cash_receipt_history_all crh,
4063: --xla_upgrade_dates gps,
4064: ar_receipt_methods rmth,
4065: ar_cash_receipt_history_all crh1,
4066: xla_transaction_entities_upg te
4067: WHERE NVL(cr.ax_accounted_flag,'N') = 'N'
4180: te.entity_id ENTITY_ID
4181: FROM ar_cash_receipts_all cr,
4182: --ar_system_parameters_all sys,
4183: ar_misc_cash_distributions_all mcd,
4184: --xla_upgrade_dates gps,
4185: ar_receipt_methods rmth,
4186: ar_cash_receipt_history_all crh,
4187: xla_transaction_entities_upg te
4188: WHERE NVL(cr.ax_accounted_flag,'N') = 'N'
4298: te.entity_id ENTITY_ID
4299: FROM ar_cash_receipts_all cr,
4300: -- ar_system_parameters_all sys,
4301: ar_receivable_applications_all app,
4302: -- xla_upgrade_dates gps,
4303: ar_cash_receipt_history_all crh,
4304: ar_cash_receipt_history_all crh1,
4305: ar_receipt_methods rmth,
4306: xla_transaction_entities_upg te
4615: 1 ln_order,
4616: nvl((select max(ae_line_num) from xla_ae_lines ael where ael.ae_header_id=hdr.ae_header_id and application_id=222),1000) max_line_num
4617: from ar_cash_receipts_all cr,
4618: ar_cash_receipt_history_all crh,
4619: -- xla_upgrade_dates gps,
4620: ar_cash_receipt_history_all crh1,
4621: xla_transaction_entities_upg ent,
4622: xla_events ev,
4623: xla_ae_headers hdr,
4720: nvl((select max(ae_line_num) from xla_ae_lines ael where ael.ae_header_id=hdr.ae_header_id and application_id=222),1000) max_line_num
4721: from ar_cash_receipts_all cr,
4722: ar_system_parameters_all sys,
4723: ar_receivable_applications_all app,
4724: -- xla_upgrade_dates gps,
4725: xla_transaction_entities_upg ent,
4726: ar_cash_receipt_history_all crh,
4727: ar_cash_receipt_history_all crh1,
4728: xla_events ev,
4806: 1 ln_order,
4807: nvl((select max(ae_line_num) from xla_ae_lines ael where ael.ae_header_id=hdr.ae_header_id and application_id=222),1000) max_line_num
4808: from ar_cash_receipts_all cr,
4809: ar_misc_cash_distributions_all mcd,
4810: -- xla_upgrade_dates gps,
4811: ar_cash_receipt_history_all crh,
4812: xla_transaction_entities_upg ent,
4813: xla_events ev,
4814: xla_ae_headers hdr,
5077: 1 ln_order,
5078: nvl((select max(ae_line_num) from xla_ae_lines ael where ael.ae_header_id=hdr.ae_header_id and application_id=222),1000) max_line_num
5079: from ar_receivable_applications_all app,
5080: ar_system_parameters_all sys,
5081: xla_upgrade_dates gps,
5082: xla_transaction_entities_upg ent,
5083: ra_customer_trx_all ctcm,
5084: ar_cash_receipt_history_all crh1,
5085: ar_cash_receipt_history_all crh,