APPS.OKC_OC_INT_KTQ_PVT dependencies on OKX_SYSTEM_ITEMS_V

Line 173: g_okx_system_items_v CONSTANT VARCHAR2(30) := 'OKX_SYSTEM_ITEMS_V';

169: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
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';

Line 359: ,okx_system_items_v sit

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
363: AND cpt.id2 = cim.object1_id2

Line 369: g_okx_system_items_v||'%'||cim.jtot_object1_code)

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

Line 609: ,prod_name okx_system_items_v.name%TYPE

605: ,line_source_table jtf_objects_b.from_table%TYPE
606: --
607: ,id1 okc_k_items.object1_id1%TYPE
608: ,id2 okc_k_items.object1_id2%TYPE
609: ,prod_name okx_system_items_v.name%TYPE
610: ,item_source_code jtf_objects_b.object_code%TYPE
611: ,item_source_table jtf_objects_b.from_table%TYPE
612: --
613: ,svc_duration okx_quote_line_detail_v.service_duration%TYPE

Line 1576: -- okx_system_items_v sit,

1572: okc_line_style_sources lss,
1573: jtf_objects_b jot,
1574: jtf_objects_b jot2,
1575: okc_statuses_b sts,
1576: -- okx_system_items_v sit,
1577: okx_config_items_v cfg
1578: WHERE
1579: cim.cle_id = cle.id
1580: AND jot.object_code(+) = cim.jtot_object1_code

Line 1847: g_okx_system_items_v||'%'||r_cle.item_source_code THEN

1843: END IF;
1844:
1845: IF rtrim(ltrim(r_cle.item_source_code)) IS NOT NULL THEN
1846: IF rtrim(ltrim(r_cle.item_source_table)) NOT LIKE
1847: g_okx_system_items_v||'%'||r_cle.item_source_code THEN
1848: BEGIN
1849: l_sql:= 'SELECT name FROM '||r_cle.item_source_table ||' WHERE id1 = :b AND id2 = :c';
1850: EXECUTE IMMEDIATE l_sql INTO l_item_name USING r_cle.object_id1, r_cle.object_id2;
1851: END;