DBA Data[Home] [Help]

APPS.JL_AR_RECEIVABLE_APPLICATIONS dependencies on RA_CUSTOMER_TRX

Line 90: FROM ra_customer_trx

86: --Bug 12323016 end
87:
88: SELECT trx_date
89: INTO x_trans_date
90: FROM ra_customer_trx
91: WHERE customer_trx_id = x_customer_trx_id;
92:
93: --Bug 12742020 start
94:

Line 106: ra_customer_trx ract,

102: x_org_id
103: FROM hz_locations loc,
104: hz_cust_acct_sites ad,
105: hz_party_sites pty,
106: ra_customer_trx ract,
107: hz_cust_site_uses rasu,
108: ar_payment_schedules arps,
109: jl_br_ar_collection_docs dc
110: WHERE dc.payment_schedule_id = x_payment_schedule_id

Line 1672: FROM ra_customer_trx ract,

1668: l_due_date,
1669: l_amount_due_remaining,
1670: l_cust_trx_id,
1671: l_payment_amount
1672: FROM ra_customer_trx ract,
1673: ar_payment_schedules arps
1674: WHERE arps.payment_schedule_id = rint.applied_payment_schedule_id
1675: AND ract.customer_trx_id = arps.customer_trx_id;
1676: