APPS.JE_IT_LISTING_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 988: FROM ra_customer_trx_all rth,

984: DECODE(rtp.type,'CM',ROUND(rcgl.amount*NVL(rth.exchange_rate, 1),2),0) cm_amount_tax, --Inv_Line_Amt
985: DECODE(rtp.type,'CM',0,ROUND(rcglitem.amount*NVL(rth.exchange_rate, 1),2)) amount_item, --Inv_Line_Amt
986: decode(rtp.type,'CM',ROUND(rcglitem.amount*NVL(rth.exchange_rate, 1),2),0) cm_amount_item
987:
988: FROM ra_customer_trx_all rth,
989: ra_customer_trx_lines_all rtl,
990: ra_cust_trx_line_gl_dist_all rcgl,
991: ra_customer_trx_lines_all rtlitem,
992: ra_cust_trx_line_gl_dist_all rcglitem,

Line 1048: ra_customer_trx_all arct

1044: AND ( (rtp.type <> 'CM') or
1045: (rtp.type = 'CM'
1046: and EXISTS(SELECT arct.customer_trx_id
1047: FROM ar_receivable_applications_all arap,
1048: ra_customer_trx_all arct
1049: WHERE arap.customer_trx_id = rth.customer_trx_id
1050: AND application_type ='CM'
1051: AND arap.applied_customer_trx_id = arct.customer_trx_id
1052: AND TO_CHAR(arct.trx_date, 'YYYY') = TO_CHAR(add_months(gd_period_end_date,-12), 'YYYY')