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

Line 904: , okc_operation_lines ren_rel

900: ) subsequent_renewal_type_code /* Added this colunm as a part of ER#5760744 */
901: ,h.term_cancel_source hdr_term_cancel_source /* for ER6684955 */
902: FROM oki_dbi_chr_stage_inc inc
903: , okc_k_headers_all_b h
904: , okc_operation_lines ren_rel
905: , oki_dbi_chr_stage_inc inc2
906: , okc_operation_instances opins
907: WHERE 1=1
908: AND ren_rel.object_chr_id = h.ID

Line 1634: okc_operation_lines ren_rel ,

1630: 'NSR', decode(h.approval_type, 'Y', 'NSR', 'N', 'NSR', 'NSR')
1631: ) subsequent_renewal_type_code /* Added this colunm as a part of ER#5760744 */
1632: , h.term_cancel_source hdr_term_cancel_source /* Added for ER 6684955 */
1633: FROM oki_dbi_chr_stage_inc inc ,
1634: okc_operation_lines ren_rel ,
1635: okc_operation_instances opins,
1636: okc_k_headers_all_b h
1637: WHERE 1=1
1638: AND ren_rel.object_chr_id = h.id

Line 2773: FROM okc_operation_lines okl

2769: AND rownum=1 )
2770: /* End of for line level order number */
2771: ELSE h.order_number END order_number
2772: , NVL(( SELECT 1
2773: FROM okc_operation_lines okl
2774: , okc_operation_instances opins
2775: WHERE okl.oie_id=opins.id
2776: AND opins.cop_id in (g_renewal_id,g_ren_con_id)
2777: AND object_cle_id IS NOT NULL

Line 3032: FROM OKC_OPERATION_LINES REL ,

3028: FROM (SELECT /*+ ordered use_nl(OPINS,CLSOP)*/
3029: rel.object_cle_id cle_id
3030: , MAX(rel.subject_cle_id) KEEP (DENSE_RANK LAST
3031: ORDER BY rel.last_update_date) r_cle_id
3032: FROM OKC_OPERATION_LINES REL ,
3033: OKC_OPERATION_INSTANCES OPINS,
3034: OKC_CLASS_OPERATIONS CLSOP
3035: WHERE 1 = 1
3036: AND rel.oie_id=opins.id

Line 3097: okc_operation_lines rel

3093: FROM (SELECT /*+ ordered index(b) use_nl(rel,opins) */
3094: rel.object_cle_id cle_id
3095: , MAX (rel.subject_cle_id)KEEP (DENSE_RANK LAST ORDER BY rel.last_update_date) r_cle_id
3096: FROM oki_dbi_ren_inc b,
3097: okc_operation_lines rel
3098: ,okc_operation_instances opins,
3099: okc_class_operations clsop
3100: WHERE 1 = 1
3101: AND rel.oie_id=opins.id

Line 3153: , okc_operation_lines rl

3149: , MAX(rl.subject_cle_id) KEEP (DENSE_RANK LAST
3150: ORDER BY rl.last_update_date) r_cle_id
3151: FROM oki_dbi_cle_del del1
3152: , oki_dbi_cle_b del
3153: , okc_operation_lines rl
3154: , okc_operation_instances opins
3155: , okc_class_operations clsop
3156: WHERE 1 = 1
3157: AND rl.oie_id=opins.id

Line 5054: FROM okc_operation_lines okl

5050: (
5051: SELECT
5052: newilv.*,
5053: (SELECT DECODE(COUNT(1), 0, 0, 1) renewal_flag
5054: FROM okc_operation_lines okl
5055: , okc_operation_instances opins
5056: WHERE rownum=1
5057: AND okl.object_cle_id IS NOT NULL
5058: AND okl.subject_cle_id IS NOT NULL

Line 5233: /*, okc_operation_lines okl

5229: FROM okc_line_styles_b n
5230: where lse_parent_id in (l_service_code,l_warranty_code,l_ext_warr_code)
5231: ) root_temp
5232: , oks_k_lines_b oksl
5233: /*, okc_operation_lines okl
5234: , okc_operation_instances OPINS */
5235: , okc_k_items itm2
5236: , csi_item_instances cii
5237: , ( /* rel objs has multiple entries for the same order number */

Line 5249: FROM okc_operation_lines okl

5245: group by okcrel.cle_id
5246: ) oehdr
5247: , ( SELECT object_cle_id ,
5248: MAX(subject_cle_id) KEEP (DENSE_RANK LAST ORDER BY okl.last_update_date) subject_cle_id
5249: FROM okc_operation_lines okl
5250: , okc_operation_instances opins
5251: WHERE
5252: okl.object_cle_id IS NOT NULL
5253: AND okl.subject_cle_id IS NOT NULL