APPS.OKS_OC_INT_KTO_PVT dependencies on OKC_K_ITEMS

Line 114: ,qty okc_k_items.number_of_items%TYPE

110: ,cle_id okc_k_lines_v.cle_id%TYPE
111: ,lse_id okc_k_lines_v.lse_id%TYPE
112: ,line_number okc_k_lines_v.line_number%TYPE
113: ,status_code okc_statuses_b.ste_code%TYPE
114: ,qty okc_k_items.number_of_items%TYPE
115: ,uom_code okc_k_items.uom_code%TYPE
116: ,customer_order_enabled_flag VARCHAR2(1)
117: ,item_name okc_k_lines_v.name%TYPE
118: ,priced_item_yn okc_k_items.priced_item_yn%TYPE

Line 115: ,uom_code okc_k_items.uom_code%TYPE

111: ,lse_id okc_k_lines_v.lse_id%TYPE
112: ,line_number okc_k_lines_v.line_number%TYPE
113: ,status_code okc_statuses_b.ste_code%TYPE
114: ,qty okc_k_items.number_of_items%TYPE
115: ,uom_code okc_k_items.uom_code%TYPE
116: ,customer_order_enabled_flag VARCHAR2(1)
117: ,item_name okc_k_lines_v.name%TYPE
118: ,priced_item_yn okc_k_items.priced_item_yn%TYPE
119: ,price_unit okc_k_lines_v.price_unit%TYPE

Line 118: ,priced_item_yn okc_k_items.priced_item_yn%TYPE

114: ,qty okc_k_items.number_of_items%TYPE
115: ,uom_code okc_k_items.uom_code%TYPE
116: ,customer_order_enabled_flag VARCHAR2(1)
117: ,item_name okc_k_lines_v.name%TYPE
118: ,priced_item_yn okc_k_items.priced_item_yn%TYPE
119: ,price_unit okc_k_lines_v.price_unit%TYPE
120: ,price_negotiated okc_k_lines_v.price_negotiated%TYPE
121: ,line_list_price okc_k_lines_v.line_list_price%TYPE
122: ,price_list_id okc_k_lines_v.price_list_id%TYPE

Line 127: ,k_item_id okc_k_items.id%TYPE

123: ,price_list_line_id okc_k_lines_v.price_list_line_id%TYPE
124: ,currency_code okc_k_lines_v.currency_code%TYPE
125: ,start_date okc_k_lines_v.start_date%TYPE
126: ,end_date okc_k_lines_v.end_date%TYPE
127: ,k_item_id okc_k_items.id%TYPE
128: ,object_id1 okc_k_items.object1_id1%TYPE
129: ,object_id2 okc_k_items.object1_id2%TYPE
130: ,line_style okc_line_styles_b.lse_type%TYPE
131: ,line_type okc_line_styles_b.lty_code%TYPE

Line 128: ,object_id1 okc_k_items.object1_id1%TYPE

124: ,currency_code okc_k_lines_v.currency_code%TYPE
125: ,start_date okc_k_lines_v.start_date%TYPE
126: ,end_date okc_k_lines_v.end_date%TYPE
127: ,k_item_id okc_k_items.id%TYPE
128: ,object_id1 okc_k_items.object1_id1%TYPE
129: ,object_id2 okc_k_items.object1_id2%TYPE
130: ,line_style okc_line_styles_b.lse_type%TYPE
131: ,line_type okc_line_styles_b.lty_code%TYPE
132: );

Line 129: ,object_id2 okc_k_items.object1_id2%TYPE

125: ,start_date okc_k_lines_v.start_date%TYPE
126: ,end_date okc_k_lines_v.end_date%TYPE
127: ,k_item_id okc_k_items.id%TYPE
128: ,object_id1 okc_k_items.object1_id1%TYPE
129: ,object_id2 okc_k_items.object1_id2%TYPE
130: ,line_style okc_line_styles_b.lse_type%TYPE
131: ,line_type okc_line_styles_b.lty_code%TYPE
132: );
133:

Line 634: okc_k_items cim,

630: ,lse.lse_type line_style
631: ,lse.lty_code line_type
632: FROM
633: okc_k_lines_v cle,
634: okc_k_items cim,
635: okc_line_styles_b lse,
636: okc_statuses_b sts
637: WHERE
638: cim.cle_id = cle.id