APPS.OKC_OC_INT_KTQ_PVT dependencies on OKC_LINE_STYLES_B

Line 298: ,okc_line_styles_b lse

294: FROM
295: jtf_objects_b jot
296: ,okc_k_lines_b cle
297: ,okc_k_items cim
298: ,okc_line_styles_b lse
299: ,okc_line_style_sources lss
300: ,okx_customer_products_v cpt
301: ,okc_statuses_b sts
302: WHERE

Line 356: ,okc_line_styles_b lse

352: ,jot.from_table
353: FROM jtf_objects_b jot
354: ,okc_k_lines_b cle
355: ,okc_k_items cim
356: ,okc_line_styles_b lse
357: ,okc_line_style_sources lss
358: ,okx_product_lines_v cpt
359: ,okx_system_items_v sit
360: ,okc_statuses_b sts

Line 573: ,line_style okc_line_styles_b.lse_type%TYPE

569: ,k_item_id okc_k_items.id%TYPE
570: ,object_id1 okc_k_items.object1_id1%TYPE
571: ,object_id2 okc_k_items.object1_id2%TYPE
572: --
573: ,line_style okc_line_styles_b.lse_type%TYPE
574: ,line_type okc_line_styles_b.lty_code%TYPE
575: ,line_source_code okc_line_style_sources.jtot_object_code%TYPE
576: ,line_source_table jtf_objects_b.from_table%TYPE
577: --

Line 574: ,line_type okc_line_styles_b.lty_code%TYPE

570: ,object_id1 okc_k_items.object1_id1%TYPE
571: ,object_id2 okc_k_items.object1_id2%TYPE
572: --
573: ,line_style okc_line_styles_b.lse_type%TYPE
574: ,line_type okc_line_styles_b.lty_code%TYPE
575: ,line_source_code okc_line_style_sources.jtot_object_code%TYPE
576: ,line_source_table jtf_objects_b.from_table%TYPE
577: --
578: ,item_source_code okc_k_items.jtot_object1_code%TYPE

Line 602: ,line_style okc_line_styles_b.lse_type%TYPE

598: --
599: ,start_date okc_k_lines_b.start_date%TYPE
600: ,end_date okc_k_lines_b.end_date%TYPE
601: --
602: ,line_style okc_line_styles_b.lse_type%TYPE
603: ,line_type okc_line_styles_b.lty_code%TYPE
604: ,line_source_code jtf_objects_b.object_code%TYPE
605: ,line_source_table jtf_objects_b.from_table%TYPE
606: --

Line 603: ,line_type okc_line_styles_b.lty_code%TYPE

599: ,start_date okc_k_lines_b.start_date%TYPE
600: ,end_date okc_k_lines_b.end_date%TYPE
601: --
602: ,line_style okc_line_styles_b.lse_type%TYPE
603: ,line_type okc_line_styles_b.lty_code%TYPE
604: ,line_source_code jtf_objects_b.object_code%TYPE
605: ,line_source_table jtf_objects_b.from_table%TYPE
606: --
607: ,id1 okc_k_items.object1_id1%TYPE

Line 1160: FUNCTION is_top_line_style_seeded(p_lse_id IN okc_line_styles_b.id%TYPE,

1156: -- In Parameters: p_lse_id record of line information
1157: -- Out Parameters: x_index Index value of the l_line_style_tab rec that
1158: -- matches the line style id that is passed
1159:
1160: FUNCTION is_top_line_style_seeded(p_lse_id IN okc_line_styles_b.id%TYPE,
1161: x_index OUT NOCOPY NUMBER) RETURN VARCHAR IS
1162: l_retval VARCHAR2(1):= OKC_API.G_FALSE;
1163:
1164: BEGIN

Line 1188: FUNCTION is_top_line_with_covered_prod(p_lse_id IN okc_line_styles_b.id%TYPE,

1184: -- object_code of OKX_SERVICE
1185: -- In Parameters: p_lse_id
1186: -- Out Parameters: p_index
1187:
1188: FUNCTION is_top_line_with_covered_prod(p_lse_id IN okc_line_styles_b.id%TYPE,
1189: p_index IN NUMBER DEFAULT OKC_API.G_MISS_NUM )
1190: RETURN VARCHAR IS
1191:
1192: l_retval VARCHAR2(1):= OKC_API.G_FALSE;

Line 1227: p_lse_id IN okc_line_styles_b.id%TYPE,

1223: -- p_index
1224: --
1225:
1226: FUNCTION is_top_line_orderable_i(p_cust_ord_enabled_flag IN VARCHAR2,
1227: p_lse_id IN okc_line_styles_b.id%TYPE,
1228: p_index IN NUMBER
1229: ) RETURN VARCHAR IS
1230:
1231: l_retval VARCHAR2(1) := OKC_API.G_TRUE;

Line 1571: okc_line_styles_b lse,

1567: ,jot.from_table item_source_table
1568: FROM
1569: okc_k_lines_v cle,
1570: okc_k_items cim,
1571: okc_line_styles_b lse,
1572: okc_line_style_sources lss,
1573: jtf_objects_b jot,
1574: jtf_objects_b jot2,
1575: okc_statuses_b sts,