APPS.IEX_AGING_BUCKETS_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 855: ra_cust_trx_line_gl_dist gld

851: SELECT NVL( SUM( DECODE(p_currency_code, NULL,
852: ps.acctd_amount_due_remaining,
853: ps.amount_due_remaining)), 0)
854: FROM ar_payment_schedules ps,
855: ra_cust_trx_line_gl_dist gld
856: WHERE ps.customer_id = p_filter_id
857: AND decode(p_customer_site_use_id,
858: NULL, ps.customer_site_use_id,
859: p_customer_site_use_id) = ps.customer_site_use_id

Line 875: ra_cust_trx_line_gl_dist gld

871: SELECT NVL( SUM( DECODE(p_currency_code, NULL,
872: ps.acctd_amount_due_remaining,
873: ps.amount_due_remaining)), 0)
874: FROM ar_payment_schedules ps,
875: ra_cust_trx_line_gl_dist gld
876: WHERE ps.customer_site_use_id = p_filter_id
877: AND decode(upper(p_currency_code),
878: NULL, ps.invoice_currency_code,
879: upper(p_currency_code)) = ps.invoice_currency_code

Line 893: ra_cust_trx_line_gl_dist gld,

889: SELECT NVL( SUM( DECODE(p_currency_code, NULL,
890: ps.acctd_amount_due_remaining,
891: ps.amount_due_remaining)), 0)
892: FROM ar_payment_schedules ps,
893: ra_cust_trx_line_gl_dist gld,
894: hz_cust_accounts hzca
895: WHERE ps.customer_id = hzca.cust_account_id
896: AND hzca.party_id = p_filter_id
897: AND decode(p_customer_site_use_id,

Line 915: ra_cust_trx_line_gl_dist gld,

911: SELECT NVL( SUM( DECODE(p_currency_code, NULL,
912: ps.acctd_amount_due_remaining,
913: ps.amount_due_remaining)), 0)
914: FROM ar_payment_schedules ps,
915: ra_cust_trx_line_gl_dist gld,
916: hz_cust_accounts hzca
917: WHERE ps.customer_id = hzca.cust_account_id
918: AND hzca.party_id IN
919: (SELECT p_filter_id FROM dual