DBA Data[Home] [Help]

APPS.ARP_ADJUSTMENTS_MAIN dependencies on AR_REC_TRX_LE_DETAILS

Line 925: /* 5236782 - but ar_rec_trx_le_details not required for adj */

921:
922: IF arp_legal_entity_util.is_le_subscriber
923: THEN
924: /* LE setup is enabled */
925: /* 5236782 - but ar_rec_trx_le_details not required for adj */
926: select adj.adjustment_id ,
927: adj.customer_trx_id ,
928: adj.customer_trx_line_id ,
929: adj.payment_schedule_id ,

Line 1029: ar_rec_trx_le_details rtd ,

1025: p_rule_rec.act_tax_non_rec_ccid2 ,
1026: p_rule_rec.act_vat_tax_id2
1027: from ar_adjustments adj ,
1028: ar_receivables_trx rt ,
1029: ar_rec_trx_le_details rtd ,
1030: ra_customer_trx ctinv ,
1031: ra_cust_trx_line_gl_dist ctlgdinv
1032: where adj.adjustment_id = g_ae_doc_rec.source_id
1033: and adj.status = 'A' --only approved adjustments