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_ITEMS

Line 117: okc_k_items cim

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
120: cim.cle_id = cle.id
121: --AND jot.object_code = cim.jtot_object1_code

Line 212: item_id okc_k_items.object1_id1%type,

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,
216: list_price_per_unit okc_k_lines_b.price_unit%type,

Line 213: uom_code okc_k_items.uom_code%type,

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,
216: list_price_per_unit okc_k_lines_b.price_unit%type,
217: need_by_date okc_k_lines_b.start_date%type,

Line 214: quantity okc_k_items.number_of_items%type,

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

Line 239: quantity_ordered okc_k_items.number_of_items%type,

235: interface_header_id po_headers_interface.interface_header_id%type,
236: interface_line_id po_lines_interface.interface_line_id%type,
237: interface_distribution_id po_distributions_interface.interface_distribution_id%type,
238: org_id okc_k_headers_b.authoring_org_id%type,
239: quantity_ordered okc_k_items.number_of_items%type,
240: charge_account_id po_distributions_interface.charge_account_id%TYPE
241: );
242:
243: