APPS.OKI_DBI_LOAD_CLEB_PVT dependencies on OKC_LINE_STYLES_B

Line 2248: FROM okc_line_styles_b

2244: SELECT
2245: Decode(lty_code,'SERVICE',Id) service_code,
2246: Decode(lty_code,'WARRANTY',Id) warranty_code,
2247: Decode(lty_code,'EXT_WARRANTY',Id) ext_warr_code
2248: FROM okc_line_styles_b
2249: WHERE lty_code IN ('SERVICE','WARRANTY','EXT_WARRANTY')
2250: AND lse_parent_id IS NULL
2251: );
2252:

Line 2844: FROM okc_line_styles_b n

2840: case lse_parent_id when l_service_code then 'SERVICE'
2841: when l_warranty_code then 'WARRANTY'
2842: when l_ext_warr_code then 'EXT_WARRANTY'
2843: END root_lty_code
2844: FROM okc_line_styles_b n
2845: where lse_parent_id = l_service_code
2846: or lse_parent_id = l_warranty_code
2847: or lse_parent_id = l_ext_warr_code ) root_temp
2848: , okc_k_items itm2

Line 4606: FROM okc_line_styles_b

4602: SELECT
4603: Decode(lty_code,'SERVICE',Id) service_code,
4604: Decode(lty_code,'WARRANTY',Id) warranty_code,
4605: Decode(lty_code,'EXT_WARRANTY',Id) ext_warr_code
4606: FROM okc_line_styles_b
4607: WHERE lty_code IN ('SERVICE','WARRANTY','EXT_WARRANTY')
4608: AND lse_parent_id IS NULL
4609: );
4610:

Line 5229: FROM okc_line_styles_b n

5225: and qpl.lookup_type(+) = 'QP_AGREEMENT_TYPE'
5226: and qpl.lookup_code(+) = oab.agreement_type_code
5227: ) agmt /* for ER 6062516 */
5228: , ( Select /*+ no_merge */ id,lty_code,decode(lse_parent_id,l_service_code,'SERVICE',l_warranty_code,'WARRANTY',l_ext_warr_code,'EXT_WARRANTY') root_lty_code
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