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 OKS_IB_CONFIG_V

Line 2590: FROM oks_ib_config_v a

2586:
2587: /*check model item*/
2588: CURSOR level1_csr IS
2589: SELECT a.customer_product_id
2590: FROM oks_ib_config_v a
2591: WHERE a.config_parent_id IS NULL
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

Line 2622: FROM oks_ib_config_v b

2618:
2619: /*check config item*/
2620: CURSOR level2_csr IS
2621: SELECT b.customer_product_id
2622: FROM oks_ib_config_v b
2623: WHERE LEVEL = 2
2624: START WITH b.customer_product_id =
2625: (SELECT a.customer_product_id
2626: FROM oks_ib_config_v a

Line 2626: FROM oks_ib_config_v a

2622: FROM oks_ib_config_v b
2623: WHERE LEVEL = 2
2624: START WITH b.customer_product_id =
2625: (SELECT a.customer_product_id
2626: FROM oks_ib_config_v a
2627: WHERE a.config_parent_id IS NULL
2628: START WITH a.customer_product_id = p_customer_prod_id
2629: CONNECT BY PRIOR a.config_parent_id = a.customer_product_id)
2630: CONNECT BY b.config_parent_id = PRIOR b.customer_product_id

Line 2659: FROM oks_ib_config_v b

2655:
2656: /*check config item*/
2657: CURSOR level2_csr IS
2658: SELECT b.customer_product_id
2659: FROM oks_ib_config_v b
2660: WHERE LEVEL = 2
2661: START WITH b.customer_product_id =
2662: (SELECT a.customer_product_id
2663: FROM oks_ib_config_v a

Line 2663: FROM oks_ib_config_v a

2659: FROM oks_ib_config_v b
2660: WHERE LEVEL = 2
2661: START WITH b.customer_product_id =
2662: (SELECT a.customer_product_id
2663: FROM oks_ib_config_v a
2664: WHERE a.config_parent_id IS NULL
2665: START WITH a.customer_product_id = p_customer_prod_id
2666: CONNECT BY PRIOR a.config_parent_id = a.customer_product_id)
2667: CONNECT BY b.config_parent_id = PRIOR b.customer_product_id

Line 2700: FROM oks_ib_config_v a

2696:
2697: /*check model item*/
2698: CURSOR level1_csr IS
2699: SELECT a.customer_product_id
2700: FROM oks_ib_config_v a
2701: WHERE a.config_parent_id IS NULL
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

Line 2904: FROM oks_ib_config_v a1

2900: lin.end_date,
2901: lin.price_negotiated,
2902: lin.price_negotiated,
2903: DECODE((SELECT a1.customer_product_id
2904: FROM oks_ib_config_v a1
2905: WHERE a1.config_parent_id IS NULL
2906: START WITH a1.customer_product_id =
2907: CS_ITEM.CUSTOMER_PRODUCT_ID
2908: CONNECT BY PRIOR a1.config_parent_id = a1.customer_product_id

Line 2918: FROM oks_ib_config_v b1

2914: CS_ITEM.CUSTOMER_PRODUCT_ID,
2915: -99,
2916: NULL,
2917: DECODE((SELECT b1.customer_product_id
2918: FROM oks_ib_config_v b1
2919: WHERE LEVEL = 2
2920: START WITH b1.customer_product_id =
2921: (SELECT a.customer_product_id
2922: FROM oks_ib_config_v a

Line 2922: FROM oks_ib_config_v a

2918: FROM oks_ib_config_v b1
2919: WHERE LEVEL = 2
2920: START WITH b1.customer_product_id =
2921: (SELECT a.customer_product_id
2922: FROM oks_ib_config_v a
2923: WHERE a.config_parent_id IS NULL
2924: START WITH a.customer_product_id =
2925: CS_ITEM.CUSTOMER_PRODUCT_ID
2926: CONNECT BY PRIOR a.config_parent_id =

Line 2941: FROM OKS_IB_CONFIG_V A

2937: CS_ITEM.CUSTOMER_PRODUCT_ID,
2938: -99,
2939: NULL,
2940: (SELECT A.CUSTOMER_PRODUCT_ID
2941: FROM OKS_IB_CONFIG_V A
2942: WHERE A.CONFIG_PARENT_ID IS NULL
2943: START WITH A.CUSTOMER_PRODUCT_ID =
2944: CS_ITEM.CUSTOMER_PRODUCT_ID
2945: CONNECT BY A.CUSTOMER_PRODUCT_ID = PRIOR

Line 2948: FROM oks_ib_config_v b1

2944: CS_ITEM.CUSTOMER_PRODUCT_ID
2945: CONNECT BY A.CUSTOMER_PRODUCT_ID = PRIOR
2946: A.CONFIG_PARENT_ID),
2947: (SELECT b1.customer_product_id
2948: FROM oks_ib_config_v b1
2949: WHERE LEVEL = 2
2950: START WITH b1.customer_product_id =
2951: (SELECT a.customer_product_id
2952: FROM oks_ib_config_v a

Line 2952: FROM oks_ib_config_v a

2948: FROM oks_ib_config_v b1
2949: WHERE LEVEL = 2
2950: START WITH b1.customer_product_id =
2951: (SELECT a.customer_product_id
2952: FROM oks_ib_config_v a
2953: WHERE a.config_parent_id IS NULL
2954: START WITH a.customer_product_id =
2955: CS_ITEM.CUSTOMER_PRODUCT_ID
2956: CONNECT BY PRIOR a.config_parent_id =

Line 2968: FROM oks_ib_config_v a1

2964: itm1.object1_id1
2965: AND itm1.dnz_chr_id = ITM.DNZ_CHR_ID)
2966: AND ROWNUM = 1)),
2967: (SELECT a1.customer_product_id
2968: FROM oks_ib_config_v a1
2969: WHERE a1.config_parent_id IS NULL
2970: START WITH a1.customer_product_id =
2971: CS_ITEM.CUSTOMER_PRODUCT_ID
2972: CONNECT BY PRIOR a1.config_parent_id = a1.customer_product_id

Line 2994: FROM oks_ib_config_v a

2990: (CASE
2991: WHEN oks_model_check(itm.dnz_chr_id,
2992: cs_item.customer_product_id) = 'Y' THEN
2993: (SELECT a.customer_product_id
2994: FROM oks_ib_config_v a
2995: WHERE a.config_parent_id IS null
2996: START WITH a.customer_product_id =
2997: cs_item.customer_product_id
2998: CONNECT BY a.customer_product_id = PRIOR a.config_parent_id)

Line 3002: FROM oks_ib_config_v b

2998: CONNECT BY a.customer_product_id = PRIOR a.config_parent_id)
2999: WHEN oks_config_check(itm.dnz_chr_id,
3000: cs_item.customer_product_id) = 'Y' THEN
3001: (SELECT b.customer_product_id
3002: FROM oks_ib_config_v b
3003: WHERE LEVEL = 2
3004: START WITH b.customer_product_id =
3005: (SELECT a.customer_product_id
3006: FROM oks_ib_config_v a

Line 3006: FROM oks_ib_config_v a

3002: FROM oks_ib_config_v b
3003: WHERE LEVEL = 2
3004: START WITH b.customer_product_id =
3005: (SELECT a.customer_product_id
3006: FROM oks_ib_config_v a
3007: WHERE a.config_parent_id IS NULL
3008: START WITH a.customer_product_id =
3009: cs_item.customer_product_id
3010: CONNECT BY PRIOR a.config_parent_id =

Line 3019: FROM oks_ib_config_v a

3015: AND cle_id = itm.cle_id)
3016: AND ROWNUM = 1)
3017: ELSE
3018: (SELECT a.customer_product_id
3019: FROM oks_ib_config_v a
3020: WHERE a.config_parent_id IS null
3021: START WITH a.customer_product_id =
3022: cs_item.customer_product_id
3023: CONNECT BY a.customer_product_id = PRIOR a.config_parent_id)

Line 3030: FROM oks_ib_config_v a

3026: WHEN cs_item.config_parent_id IS NULL THEN
3027: -99
3028: ELSE
3029: (SELECT a.customer_product_id
3030: FROM oks_ib_config_v a
3031: WHERE a.config_parent_id IS null
3032: START WITH a.customer_product_id =
3033: cs_item.customer_product_id
3034: CONNECT BY a.customer_product_id = PRIOR

Line 3041: oks_ib_config_v cs_item,

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,
3043: CSI_SYSTEMS_TL CSTL
3044: WHERE itm.object1_id1 = cs_item.customer_product_id
3045: AND cs_item.system_id = cstl.system_id(+)

Line 3284: FROM oks_ib_config_v a

3280: WHEN cs_item.config_parent_id IS NULL THEN
3281: 'Star Item'
3282: ELSE
3283: (SELECT To_Char(a.customer_product_id)
3284: FROM oks_ib_config_v a
3285: WHERE a.config_parent_id IS null
3286: START WITH a.customer_product_id =
3287: cs_item.customer_product_id
3288: CONNECT BY a.customer_product_id = PRIOR a.config_parent_id)

Line 3313: FROM oks_ib_config_v a

3309: WHEN cs_item.config_parent_id IS NULL THEN
3310: -99
3311: ELSE
3312: (SELECT a.customer_product_id
3313: FROM oks_ib_config_v a
3314: WHERE a.config_parent_id IS null
3315: START WITH a.customer_product_id =
3316: cs_item.customer_product_id
3317: CONNECT BY a.customer_product_id = PRIOR a.config_parent_id)

Line 3324: oks_ib_config_v cs_item,

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
3326: WHERE itm.object1_id1 = cs_item.customer_product_id
3327: AND lin.id = itm.cle_id
3328: AND lin.dnz_chr_id = p_contract_id