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 1300: okc_class_operations cls,

1296: And kl.lse_id <> 18
1297: And not exists (Select 'x'
1298: from okc_operation_instances ois,
1299: okc_operation_lines opl,
1300: okc_class_operations cls,
1301: okc_subclasses_b sl
1302: where ois.id=opl.oie_id
1303: And cls.opn_code in ('RENEWAL','REN_CON')
1304: And sl.code= 'SERVICE'

Line 1402: okc_class_operations cls,

1398: And kl.lse_id <> 18
1399: And not exists (Select 'x'
1400: from okc_operation_instances ois,
1401: okc_operation_lines opl,
1402: okc_class_operations cls,
1403: okc_subclasses_b sl
1404: where ois.id=opl.oie_id
1405: And cls.opn_code in ('RENEWAL','REN_CON')
1406: And sl.code= 'SERVICE'

Line 1507: okc_class_operations cls,

1503: OR ( trunc(KL.end_date) < trunc(tmp.Termination_date)
1504: And not exists (Select 'x'
1505: from okc_operation_instances ois,
1506: okc_operation_lines opl,
1507: okc_class_operations cls,
1508: okc_subclasses_b sl
1509: where ois.id=opl.oie_id
1510: And cls.opn_code in ('RENEWAL','REN_CON')
1511: And sl.code= 'SERVICE'

Line 1606: okc_class_operations cls,

1602: And kl.lse_id <> 18
1603: And not exists (Select 'x'
1604: from okc_operation_instances ois,
1605: okc_operation_lines opl,
1606: okc_class_operations cls,
1607: okc_subclasses_b sl
1608: where ois.id=opl.oie_id
1609: And cls.opn_code in ('RENEWAL','REN_CON')
1610: And sl.code= 'SERVICE'

Line 1709: okc_class_operations cls,

1705: OR ( trunc(KL.end_date) < trunc(tmp.Termination_date)
1706: And not exists (Select 'x'
1707: from okc_operation_instances ois,
1708: okc_operation_lines opl,
1709: okc_class_operations cls,
1710: okc_subclasses_b sl
1711: where ois.id=opl.oie_id
1712: And cls.opn_code in ('RENEWAL','REN_CON')
1713: And sl.code= 'SERVICE'

Line 3208: okc_class_operations cls,

3204: (cl.end_date < p_transaction_date
3205: and not exists (Select 'x'
3206: from okc_operation_instances ois,
3207: okc_operation_lines opl,
3208: okc_class_operations cls,
3209: okc_subclasses_b sl
3210: where ois.id=opl.oie_id
3211: And cls.opn_code in ('RENEWAL','REN_CON')
3212: And sl.code= 'SERVICE'

Line 3238: okc_class_operations cls,

3234: (cl.end_date < p_transaction_date
3235: and not exists (Select 'x'
3236: from okc_operation_instances ois,
3237: okc_operation_lines opl,
3238: okc_class_operations cls,
3239: okc_subclasses_b sl
3240: where ois.id=opl.oie_id
3241: And cls.opn_code in ('RENEWAL','REN_CON')
3242: And sl.code= 'SERVICE'

Line 3274: okc_class_operations cls,

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

Line 3307: okc_class_operations cls,

3303: (cl.end_date < p_transaction_date
3304: and not exists (select 'x'
3305: from okc_operation_instances ois,
3306: okc_operation_lines opl,
3307: okc_class_operations cls,
3308: okc_subclasses_b sl
3309: where ois.id=opl.oie_id
3310: And cls.opn_code in ('RENEWAL','REN_CON')
3311: And sl.code= 'SERVICE'