APPS.ARP_RECEIPTS_MAIN dependencies on AR_REC_TRX_LE_DETAILS

Line 1574: in ar_rec_trx_le_details. The following sql has

1570: THEN
1571: /* LE is in use */
1572:
1573: /* 5236782 - there are cases where no rows will exist
1574: in ar_rec_trx_le_details. The following sql has
1575: been modified to ignore these cases without error */
1576:
1577: select nvl(ed.gl_account_source,'NO_SOURCE') ,
1578: nvl(ed.tax_code_source,'NO_SOURCE') ,

Line 1611: ar_rec_trx_le_details edd,

1607: p_rule_rec.act_tax_non_rec_ccid2 ,
1608: p_rule_rec.act_vat_tax_id2
1609: from ar_receipt_method_accounts rma,
1610: ar_receivables_trx ed,
1611: ar_rec_trx_le_details edd,
1612: ar_receivables_trx uned,
1613: ar_rec_trx_le_details unedd
1614: where rma.receipt_method_id = p_cr_rec.receipt_method_id
1615: and rma.remit_bank_acct_use_id = p_cr_rec.remit_bank_acct_use_id

Line 1613: ar_rec_trx_le_details unedd

1609: from ar_receipt_method_accounts rma,
1610: ar_receivables_trx ed,
1611: ar_rec_trx_le_details edd,
1612: ar_receivables_trx uned,
1613: ar_rec_trx_le_details unedd
1614: where rma.receipt_method_id = p_cr_rec.receipt_method_id
1615: and rma.remit_bank_acct_use_id = p_cr_rec.remit_bank_acct_use_id
1616: and rma.edisc_receivables_trx_id = ed.receivables_trx_id (+)
1617: and ed.receivables_trx_id = edd.receivables_trx_id (+)