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_MASS_UPD_PVT dependencies on OKC_K_ITEMS

Line 2596: FROM okc_k_items itm

2592: START WITH a.customer_product_id = p_customer_prod_id
2593: CONNECT BY PRIOR a.config_parent_id = a.customer_product_id
2594: AND EXISTS
2595: (SELECT 1
2596: FROM okc_k_items itm
2597: where a.customer_product_id = itm.object1_id1
2598: AND itm.dnz_chr_id = p_contract_id);
2599:
2600: BEGIN

Line 2633: FROM okc_k_items itm

2629: CONNECT BY PRIOR a.config_parent_id = a.customer_product_id)
2630: CONNECT BY b.config_parent_id = PRIOR b.customer_product_id
2631: AND EXISTS
2632: (SELECT 1
2633: FROM okc_k_items itm
2634: where b.customer_product_id = itm.object1_id1
2635: AND itm.dnz_chr_id = p_contract_id);
2636:
2637: BEGIN

Line 2670: FROM okc_k_items itm

2666: CONNECT BY PRIOR a.config_parent_id = a.customer_product_id)
2667: CONNECT BY b.config_parent_id = PRIOR b.customer_product_id
2668: AND EXISTS
2669: (SELECT 1
2670: FROM okc_k_items itm
2671: where b.customer_product_id = itm.object1_id1
2672: AND itm.dnz_chr_id = p_contract_id);
2673:
2674: BEGIN

Line 2706: FROM okc_k_items itm

2702: START WITH a.customer_product_id = p_customer_prod_id
2703: CONNECT BY PRIOR a.config_parent_id = a.customer_product_id
2704: AND EXISTS
2705: (SELECT 1
2706: FROM okc_k_items itm
2707: where a.customer_product_id = itm.object1_id1
2708: AND itm.dnz_chr_id = p_contract_id);
2709:
2710: BEGIN

Line 2828: okc_k_items itm,

2824: lin.start_date,
2825: lin.end_date,
2826: Price_negotiated
2827: FROM okc_k_lines_b lin,
2828: okc_k_items itm,
2829: OKX_SYSTEM_ITEMS_V SI,
2830: okc_statuses_b sts
2831: WHERE lin.id = itm.cle_id
2832: AND itm.object1_id1 = SI.id1

Line 2911: FROM okc_k_items itm1

2907: CS_ITEM.CUSTOMER_PRODUCT_ID
2908: CONNECT BY PRIOR a1.config_parent_id = a1.customer_product_id
2909: AND EXISTS
2910: (SELECT 1
2911: FROM okc_k_items itm1
2912: WHERE a1.customer_product_id = itm1.object1_id1
2913: AND itm1.dnz_chr_id = ITM.DNZ_CHR_ID)),
2914: CS_ITEM.CUSTOMER_PRODUCT_ID,
2915: -99,

Line 2931: FROM okc_k_items itm1

2927: a.customer_product_id)
2928: CONNECT BY b1.config_parent_id = PRIOR b1.customer_product_id
2929: AND EXISTS
2930: (SELECT 1
2931: FROM okc_k_items itm1
2932: where b1.customer_product_id =
2933: itm1.object1_id1
2934: AND itm1.dnz_chr_id = ITM.DNZ_CHR_ID)
2935: AND ROWNUM = 1)

Line 2962: FROM okc_k_items itm1

2958: CONNECT BY b1.config_parent_id = PRIOR
2959: b1.customer_product_id
2960: AND EXISTS
2961: (SELECT 1
2962: FROM okc_k_items itm1
2963: where b1.customer_product_id =
2964: itm1.object1_id1
2965: AND itm1.dnz_chr_id = ITM.DNZ_CHR_ID)
2966: AND ROWNUM = 1)),

Line 2975: FROM okc_k_items itm1

2971: CS_ITEM.CUSTOMER_PRODUCT_ID
2972: CONNECT BY PRIOR a1.config_parent_id = a1.customer_product_id
2973: AND EXISTS
2974: (SELECT 1
2975: FROM okc_k_items itm1
2976: WHERE a1.customer_product_id = itm1.object1_id1
2977: AND itm1.dnz_chr_id = ITM.DNZ_CHR_ID)
2978: AND ROWNUM = 1)) TOP_LVL_PARENT
2979: /*commented and modified above for bug14470110

Line 3013: AND EXISTS (SELECT 1 FROM okc_k_items

3009: cs_item.customer_product_id
3010: CONNECT BY PRIOR a.config_parent_id =
3011: a.customer_product_id)
3012: CONNECT BY b.config_parent_id = PRIOR b.customer_product_id
3013: AND EXISTS (SELECT 1 FROM okc_k_items
3014: WHERE object1_id1 = cs_item.customer_product_id
3015: AND cle_id = itm.cle_id)
3016: AND ROWNUM = 1)
3017: ELSE

Line 3038: FROM okc_k_items itm,

3034: CONNECT BY a.customer_product_id = PRIOR
3035: a.config_parent_id)
3036: END top_lvl_parent,*/
3037:
3038: FROM okc_k_items itm,
3039: okc_k_lines_b lin,
3040: OKX_SYSTEM_ITEMS_V SI,
3041: oks_ib_config_v cs_item,
3042: okc_statuses_b sts,

Line 3087: FROM okc_k_items itm,

3083: lin.end_date,
3084: lin.price_negotiated,
3085: lin.price_negotiated,
3086: -99 "top_lvl_parent"
3087: FROM okc_k_items itm,
3088: okc_k_lines_b lin,
3089: OKX_SYSTEM_ITEMS_V SI,
3090: okc_statuses_b sts
3091: WHERE lin.id = itm.cle_id

Line 3131: FROM okc_k_items itm,

3127: lin.end_date,
3128: lin.price_negotiated,
3129: lin.price_negotiated,
3130: -99 "top_lvl_parent"
3131: FROM okc_k_items itm,
3132: okc_k_lines_b lin,
3133: okx_parties_v SI,
3134: okc_statuses_b sts
3135: WHERE lin.id = itm.cle_id

Line 3175: FROM okc_k_items itm,

3171: lin.end_date,
3172: lin.price_negotiated,
3173: lin.price_negotiated,
3174: -99 "top_lvl_parent"
3175: FROM okc_k_items itm,
3176: okc_k_lines_b lin,
3177: okx_party_sites_v SI,
3178: okc_statuses_b sts
3179: WHERE lin.id = itm.cle_id

Line 3219: FROM okc_k_items itm,

3215: lin.end_date,
3216: lin.price_negotiated,
3217: lin.price_negotiated,
3218: -99 "top_lvl_parent"
3219: FROM okc_k_items itm,
3220: okc_k_lines_b lin,
3221: okx_systems_v SI,
3222: okc_statuses_b sts,
3223: CSI_SYSTEMS_TL CSTL

Line 3266: FROM okc_k_items itm,

3262: lin.end_date,
3263: lin.price_negotiated,
3264: lin.price_negotiated,
3265: -99 "top_lvl_parent"
3266: FROM okc_k_items itm,
3267: okc_k_lines_b lin,
3268: hz_cust_accounts c,
3269: hz_parties p,
3270: okc_statuses_b sts

Line 3321: FROM okc_k_items itm,

3317: CONNECT BY a.customer_product_id = PRIOR a.config_parent_id)
3318: END top_lvl_parent,
3319: 'N',
3320: 'N'
3321: FROM okc_k_items itm,
3322: okc_k_lines_b lin,
3323: OKX_SYSTEM_ITEMS_V SI,
3324: oks_ib_config_v cs_item,
3325: okc_statuses_b sts