eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on AR_CMGT_CREDIT_REQUESTS

Line 4549: FROM ar_cmgt_credit_requests credreq,

4545: --Bug# 12748315: Modified to fetch Party Name from HZ_PARTIES
4546: -- From lease application, get to the case folder and fetch all guarantors
4547: CURSOR c_get_guarantors(cp_lap_id IN okl_lease_applications_v.ID%TYPE) IS
4548: SELECT hzp.party_name, credreq.trx_amount amount_requested, gdata.*
4549: FROM ar_cmgt_credit_requests credreq,
4550: ar_cmgt_guarantor_data gdata,
4551: hz_parties hzp
4552: WHERE gdata.credit_request_id = credreq.credit_request_id
4553: AND credreq.source_column3 = 'LEASEAPP'

Line 4594: FROM ar_cmgt_credit_requests credreq,

4590: AND (p_role.rle_code NOT IN ('LESSEE', 'LESSOR', 'OKL_VENDOR')
4591: OR (p_role.rle_code = 'GUARANTOR'
4592: AND p_role.jtot_object1_code= 'OKX_PARTY'
4593: AND p_role.object1_id1 NOT IN ( SELECT gdata.PARTY_ID
4594: FROM ar_cmgt_credit_requests credreq,
4595: ar_cmgt_guarantor_data gdata
4596: WHERE gdata.credit_request_id = credreq.credit_request_id
4597: AND credreq.source_column3 = 'LEASEAPP'
4598: AND credreq.source_column1 = cp_lap_id