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_K_LINE_FIN_EXT_PVT dependencies on OKL_INS_POLICIES_B

Line 1146: from OKL_INS_POLICIES_B IPYB,

1142: null) SERVICE_PAYMENT_TYPE,
1143:
1144: -- insurance line 47
1145: (select IPYB.policy_number
1146: from OKL_INS_POLICIES_B IPYB,
1147: OKL_INS_POLICIES_B IPYB1
1148: where IPYB.khr_id = khr.id
1149: and IPYB.iss_code = 'QUOTE'
1150: and IPYB.ipy_id = IPYB1.id

Line 1147: OKL_INS_POLICIES_B IPYB1

1143:
1144: -- insurance line 47
1145: (select IPYB.policy_number
1146: from OKL_INS_POLICIES_B IPYB,
1147: OKL_INS_POLICIES_B IPYB1
1148: where IPYB.khr_id = khr.id
1149: and IPYB.iss_code = 'QUOTE'
1150: and IPYB.ipy_id = IPYB1.id
1151: and IPYB1.policy_number = nvl(insurance.policy_number,'XXX')) INSURANCE_QUOTE_NUMBER,

Line 3276: from OKL_INS_POLICIES_B IPYB,

3272: null) SERVICE_PAYMENT_TYPE,
3273:
3274: -- insurance line 47
3275: (select IPYB.policy_number
3276: from OKL_INS_POLICIES_B IPYB,
3277: OKL_INS_POLICIES_B IPYB1
3278: where IPYB.khr_id = khr.id
3279: and IPYB.iss_code = 'QUOTE'
3280: and IPYB.ipy_id = IPYB1.id

Line 3277: OKL_INS_POLICIES_B IPYB1

3273:
3274: -- insurance line 47
3275: (select IPYB.policy_number
3276: from OKL_INS_POLICIES_B IPYB,
3277: OKL_INS_POLICIES_B IPYB1
3278: where IPYB.khr_id = khr.id
3279: and IPYB.iss_code = 'QUOTE'
3280: and IPYB.ipy_id = IPYB1.id
3281: and IPYB1.policy_number = nvl(insurance.policy_number,'XXX')) INSURANCE_QUOTE_NUMBER,

Line 5339: from OKL_INS_POLICIES_B IPYB,

5335: null) SERVICE_PAYMENT_TYPE,
5336:
5337: -- insurance line 47
5338: (select IPYB.policy_number
5339: from OKL_INS_POLICIES_B IPYB,
5340: OKL_INS_POLICIES_B IPYB1
5341: where IPYB.khr_id = khr.id
5342: and IPYB.iss_code = 'QUOTE'
5343: and IPYB.ipy_id = IPYB1.id

Line 5340: OKL_INS_POLICIES_B IPYB1

5336:
5337: -- insurance line 47
5338: (select IPYB.policy_number
5339: from OKL_INS_POLICIES_B IPYB,
5340: OKL_INS_POLICIES_B IPYB1
5341: where IPYB.khr_id = khr.id
5342: and IPYB.iss_code = 'QUOTE'
5343: and IPYB.ipy_id = IPYB1.id
5344: and IPYB1.policy_number = nvl(insurance.policy_number,'XXX')) INSURANCE_QUOTE_NUMBER,