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_OC_INT_KTQ_PVT dependencies on OKX_PRODUCT_LINES_V

Line 174: g_okx_product_lines_v CONSTANT VARCHAR2(50) := 'OKX_PRODUCT_LINES_V';

170: G_APP_NAME1 CONSTANT VARCHAR2(3) := 'OKO';
171:
172: -- other constants
173: g_okx_system_items_v CONSTANT VARCHAR2(30) := 'OKX_SYSTEM_ITEMS_V';
174: g_okx_product_lines_v CONSTANT VARCHAR2(50) := 'OKX_PRODUCT_LINES_V';
175: g_okx_customer_products_v CONSTANT VARCHAR2(50) := 'OKX_CUSTOMER_PRODUCTS_V';
176: g_okx_operunit CONSTANT VARCHAR2(30) := 'OKX_OPERUNIT';
177: g_okx_legentity CONSTANT VARCHAR2(30) := 'OKX_LEGAL_ENTITY';
178: g_okx_service CONSTANT VARCHAR2(30) := 'OKX_SERVICE';

Line 358: ,okx_product_lines_v cpt

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
361: WHERE cim.cle_id = cle.id
362: AND cpt.id1 = cim.object1_id1

Line 368: g_okx_product_lines_v||'%'||cim.jtot_object1_code,

364: AND cpt.dnz_chr_id = cle.dnz_chr_id
365: AND jot.object_code = cim.jtot_object1_code
366: AND rtrim(ltrim(jot.from_table)) like
367: DECODE(lse.lty_code, g_lt_suppline,
368: g_okx_product_lines_v||'%'||cim.jtot_object1_code,
369: g_okx_system_items_v||'%'||cim.jtot_object1_code)
370: --
371: AND sit.organization_id = cpt.organization_id
372: AND sit.inventory_item_id = cpt.inventory_item_id