[Home] [Help]
1779: cr.doc_sequence_id DOC_SEQ_ID ,
1780: cr.doc_sequence_value DOC_SEQ_VAL ,
1781: rmth.name CAT_CODE ,
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,
1882: cr.doc_sequence_id DOC_SEQ_ID ,
1883: cr.doc_sequence_value DOC_SEQ_VAL ,
1884: rmth.name CAT_CODE ,
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,
1982: cr.doc_sequence_id DOC_SEQ_ID ,
1983: cr.doc_sequence_value DOC_SEQ_VAL ,
1984: rmth.name CAT_CODE ,
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,
2295: 'N' gain_or_loss_flag,
2296: hdr.accounting_date accounting_date,
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,
2390: 'N') gain_or_loss_flag,
2391: hdr.accounting_date accounting_date,
2392: hdr.ledger_id ledger_id,
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,
2468: 'N' gain_or_loss_flag,
2469: hdr.accounting_date accounting_date,
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,