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.

[Home] [Help]

APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on OKL_INS_POLICIES_B

Line 1145: from OKL_INS_POLICIES_B IPYB,

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

Line 1146: OKL_INS_POLICIES_B IPYB1

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

Line 3275: from OKL_INS_POLICIES_B IPYB,

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

Line 3276: OKL_INS_POLICIES_B IPYB1

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

Line 5338: from OKL_INS_POLICIES_B IPYB,

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

Line 5339: OKL_INS_POLICIES_B IPYB1

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