DBA Data[Home] [Help]

APPS.ARP_CALCULATE_DISCOUNT dependencies on RA_CUSTOMER_TRX_LINES

Line 1008: ra_customer_trx_lines rctl,

1004: DECODE(p_disc_rec.calc_disc_on_lines, 'F',
1005: rctl.extended_amount, 0))),0)
1006: INTO l_numerator
1007: FROM
1008: ra_customer_trx_lines rctl,
1009: ar_payment_schedules ps
1010: WHERE
1011: rctl.line_type IN ('LINE','TAX')
1012: AND nvl(rctl.inventory_item_id,-1) <> l_inventory_item_id

Line 1017: ra_customer_trx_lines rctl2,

1013: AND nvl(rctl.link_to_cust_trx_line_id,-1)
1014: NOT IN (
1015: SELECT rctl2.customer_trx_line_id
1016: FROM
1017: ra_customer_trx_lines rctl2,
1018: ar_payment_schedules ps2
1019: WHERE
1020: nvl(rctl2.inventory_item_id,-1) = l_inventory_item_id
1021: AND rctl2.customer_trx_id = ps2.customer_trx_id