DBA Data[Home] [Help]

APPS.ARP_ADJUSTMENTS_MAIN dependencies on AR_REC_TRX_LE_DETAILS

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

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

Line 1024: ar_rec_trx_le_details rtd ,

1020: p_rule_rec.act_tax_non_rec_ccid2 ,
1021: p_rule_rec.act_vat_tax_id2
1022: from ar_adjustments adj ,
1023: ar_receivables_trx rt ,
1024: ar_rec_trx_le_details rtd ,
1025: ra_customer_trx ctinv ,
1026: ra_cust_trx_line_gl_dist ctlgdinv
1027: where adj.adjustment_id = g_ae_doc_rec.source_id
1028: and adj.status = 'A' --only approved adjustments