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.OKC_CREATE_PO_FROM_K_PVT dependencies on OKC_K_LINES_B

Line 115: okc_k_lines_b cle,

111: ,trunc(greatest(cle.start_date, sysdate)) need_by_date
112: -- need by date cannot be earlier than sysdate according to a check
113: -- performed in PDOI. Logged bug 2166158 for this
114: FROM
115: okc_k_lines_b cle,
116: okc_statuses_b sts,
117: okc_k_items cim
118: -- jtf_objects_b jot -- (Sangeeta) not necessary to check the source
119: WHERE

Line 154: ,cle_id okc_k_lines_b.id%TYPE

150:
151: TYPE rule_rec_typ IS RECORD
152: (
153: chr_id okc_k_headers_b.id%TYPE
154: ,cle_id okc_k_lines_b.id%TYPE
155: ,object1_id1 okc_rules_b.object1_id1%TYPE
156: ,object1_id2 okc_rules_b.object1_id2%TYPE
157: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE
158: ,object2_id1 okc_rules_b.object2_id1%TYPE

Line 211: source_cle_id okc_k_lines_b.id%type,

207: -- po_line_id - primary key in po_lines_all table
208: -------------------------------------------------------------------------
209:
210: TYPE po_lines_rec_type IS RECORD(
211: source_cle_id okc_k_lines_b.id%type,
212: item_id okc_k_items.object1_id1%type,
213: uom_code okc_k_items.uom_code%type,
214: quantity okc_k_items.number_of_items%type,
215: unit_price okc_k_lines_b.price_negotiated%type,

Line 215: unit_price okc_k_lines_b.price_negotiated%type,

211: source_cle_id okc_k_lines_b.id%type,
212: item_id okc_k_items.object1_id1%type,
213: uom_code okc_k_items.uom_code%type,
214: quantity okc_k_items.number_of_items%type,
215: unit_price okc_k_lines_b.price_negotiated%type,
216: list_price_per_unit okc_k_lines_b.price_unit%type,
217: need_by_date okc_k_lines_b.start_date%type,
218: interface_line_id po_lines_interface.interface_line_id%type,
219: po_line_id po_lines_interface.po_line_id%type,

Line 216: list_price_per_unit okc_k_lines_b.price_unit%type,

212: item_id okc_k_items.object1_id1%type,
213: uom_code okc_k_items.uom_code%type,
214: quantity okc_k_items.number_of_items%type,
215: unit_price okc_k_lines_b.price_negotiated%type,
216: list_price_per_unit okc_k_lines_b.price_unit%type,
217: need_by_date okc_k_lines_b.start_date%type,
218: interface_line_id po_lines_interface.interface_line_id%type,
219: po_line_id po_lines_interface.po_line_id%type,
220: interface_header_id po_headers_interface.interface_header_id%type,

Line 217: need_by_date okc_k_lines_b.start_date%type,

213: uom_code okc_k_items.uom_code%type,
214: quantity okc_k_items.number_of_items%type,
215: unit_price okc_k_lines_b.price_negotiated%type,
216: list_price_per_unit okc_k_lines_b.price_unit%type,
217: need_by_date okc_k_lines_b.start_date%type,
218: interface_line_id po_lines_interface.interface_line_id%type,
219: po_line_id po_lines_interface.po_line_id%type,
220: interface_header_id po_headers_interface.interface_header_id%type,
221: ship_to_organization_id okc_rules_b.object1_id1%type,