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.OKS_IBINT_PUB dependencies on OKC_OPERATION_LINES

Line 1279: okc_operation_lines opl,

1275: OR ( trunc(KL.end_date) < trunc(tmp.transfer_date)
1276: And kl.lse_id <> 18
1277: And not exists (Select 'x'
1278: from okc_operation_instances ois,
1279: okc_operation_lines opl,
1280: okc_class_operations cls,
1281: okc_subclasses_b sl
1282: where ois.id=opl.oie_id
1283: And cls.opn_code in ('RENEWAL','REN_CON')

Line 1381: okc_operation_lines opl,

1377: OR ( trunc(KL.end_date) < trunc(tmp.Termination_date)
1378: And kl.lse_id <> 18
1379: And not exists (Select 'x'
1380: from okc_operation_instances ois,
1381: okc_operation_lines opl,
1382: okc_class_operations cls,
1383: okc_subclasses_b sl
1384: where ois.id=opl.oie_id
1385: And cls.opn_code in ('RENEWAL','REN_CON')

Line 1486: okc_operation_lines opl,

1482: OR (trunc(tmp.Termination_date) <= trunc(kl.start_date))
1483: OR ( trunc(KL.end_date) < trunc(tmp.Termination_date)
1484: And not exists (Select 'x'
1485: from okc_operation_instances ois,
1486: okc_operation_lines opl,
1487: okc_class_operations cls,
1488: okc_subclasses_b sl
1489: where ois.id=opl.oie_id
1490: And cls.opn_code in ('RENEWAL','REN_CON')

Line 1585: okc_operation_lines opl,

1581: OR ( trunc(KL.end_date) < trunc(tmp.Termination_date)
1582: And kl.lse_id <> 18
1583: And not exists (Select 'x'
1584: from okc_operation_instances ois,
1585: okc_operation_lines opl,
1586: okc_class_operations cls,
1587: okc_subclasses_b sl
1588: where ois.id=opl.oie_id
1589: And cls.opn_code in ('RENEWAL','REN_CON')

Line 1688: okc_operation_lines opl,

1684: OR (trunc(tmp.Termination_date) <= trunc(kl.start_date))
1685: OR ( trunc(KL.end_date) < trunc(tmp.Termination_date)
1686: And not exists (Select 'x'
1687: from okc_operation_instances ois,
1688: okc_operation_lines opl,
1689: okc_class_operations cls,
1690: okc_subclasses_b sl
1691: where ois.id=opl.oie_id
1692: And cls.opn_code in ('RENEWAL','REN_CON')

Line 3175: okc_operation_lines opl,

3171: AND (( cl.end_date >= p_transaction_date) OR
3172: (cl.end_date < p_transaction_date
3173: and not exists (Select 'x'
3174: from okc_operation_instances ois,
3175: okc_operation_lines opl,
3176: okc_class_operations cls,
3177: okc_subclasses_b sl
3178: where ois.id=opl.oie_id
3179: And cls.opn_code in ('RENEWAL','REN_CON')

Line 3205: okc_operation_lines opl,

3201: AND (( cl.end_date >= p_transaction_date) OR
3202: (cl.end_date < p_transaction_date
3203: and not exists (Select 'x'
3204: from okc_operation_instances ois,
3205: okc_operation_lines opl,
3206: okc_class_operations cls,
3207: okc_subclasses_b sl
3208: where ois.id=opl.oie_id
3209: And cls.opn_code in ('RENEWAL','REN_CON')

Line 3241: okc_operation_lines opl,

3237: AND (( cl.end_date >= p_transaction_date) OR
3238: (cl.end_date < p_transaction_date
3239: and not exists (select 'x'
3240: from okc_operation_instances ois,
3241: okc_operation_lines opl,
3242: okc_class_operations cls,
3243: okc_subclasses_b sl
3244: where ois.id=opl.oie_id
3245: And cls.opn_code in ('RENEWAL','REN_CON')

Line 3274: okc_operation_lines opl,

3270: AND (( cl.end_date >= p_transaction_date) OR
3271: (cl.end_date < p_transaction_date
3272: and not exists (select 'x'
3273: from okc_operation_instances ois,
3274: okc_operation_lines opl,
3275: okc_class_operations cls,
3276: okc_subclasses_b sl
3277: where ois.id=opl.oie_id
3278: And cls.opn_code in ('RENEWAL','REN_CON')