APPS.OKS_OC_INT_KTO_PVT dependencies on OKC_K_LINES_V

Line 109: line_id okc_k_lines_v.id%TYPE

105: AND cpr.dnz_chr_id = b_chr_id;
106:
107:
108: TYPE line_info_rec_typ IS RECORD (
109: line_id okc_k_lines_v.id%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

Line 110: ,cle_id okc_k_lines_v.cle_id%TYPE

106:
107:
108: TYPE line_info_rec_typ IS RECORD (
109: line_id okc_k_lines_v.id%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

Line 111: ,lse_id okc_k_lines_v.lse_id%TYPE

107:
108: TYPE line_info_rec_typ IS RECORD (
109: line_id okc_k_lines_v.id%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

Line 112: ,line_number okc_k_lines_v.line_number%TYPE

108: TYPE line_info_rec_typ IS RECORD (
109: line_id okc_k_lines_v.id%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)

Line 117: ,item_name okc_k_lines_v.name%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
120: ,price_negotiated okc_k_lines_v.price_negotiated%TYPE
121: ,line_list_price okc_k_lines_v.line_list_price%TYPE

Line 119: ,price_unit okc_k_lines_v.price_unit%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
123: ,price_list_line_id okc_k_lines_v.price_list_line_id%TYPE

Line 120: ,price_negotiated okc_k_lines_v.price_negotiated%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
123: ,price_list_line_id okc_k_lines_v.price_list_line_id%TYPE
124: ,currency_code okc_k_lines_v.currency_code%TYPE

Line 121: ,line_list_price okc_k_lines_v.line_list_price%TYPE

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
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

Line 122: ,price_list_id okc_k_lines_v.price_list_id%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
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

Line 123: ,price_list_line_id okc_k_lines_v.price_list_line_id%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
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

Line 124: ,currency_code okc_k_lines_v.currency_code%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
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

Line 125: ,start_date okc_k_lines_v.start_date%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
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

Line 126: ,end_date okc_k_lines_v.end_date%TYPE

122: ,price_list_id okc_k_lines_v.price_list_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

Line 299: p_cle_id IN okc_k_lines_v.id%TYPE,

295:
296: ---------------------------------------------------------------------
297:
298: PROCEDURE build_k_attributes( p_chr_id IN okc_k_headers_b.ID%TYPE,
299: p_cle_id IN okc_k_lines_v.id%TYPE,
300: x_hdr_attr_tab OUT NOCOPY kh_attr_tbl_type,
301: x_line_attr_tab OUT NOCOPY kl_attr_tbl_type,
302: x_bto_data_rec OUT NOCOPY bto_sto_rec_typ,
303: x_sto_data_rec OUT NOCOPY bto_sto_rec_typ,

Line 633: okc_k_lines_v cle,

629: ,cim.object1_id2 object1_id2
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