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_CLASS_OPERATIONS

Line 1280: okc_class_operations cls,

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')
1284: And sl.code= 'SERVICE'

Line 1382: okc_class_operations cls,

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')
1386: And sl.code= 'SERVICE'

Line 1487: okc_class_operations cls,

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')
1491: And sl.code= 'SERVICE'

Line 1586: okc_class_operations cls,

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')
1590: And sl.code= 'SERVICE'

Line 1689: okc_class_operations cls,

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')
1693: And sl.code= 'SERVICE'

Line 3176: okc_class_operations cls,

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')
3180: And sl.code= 'SERVICE'

Line 3206: okc_class_operations cls,

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')
3210: And sl.code= 'SERVICE'

Line 3242: okc_class_operations cls,

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')
3246: And sl.code= 'SERVICE'

Line 3275: okc_class_operations cls,

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')
3279: And sl.code= 'SERVICE'