APPS.OKS_EXTWAR_UTIL_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 1921: mtl_system_items_tl t

1917: IS
1918: SELECT t.description NAME,
1919: b.concatenated_segments description
1920: FROM mtl_system_items_b_kfv b,
1921: mtl_system_items_tl t
1922: WHERE
1923: b.inventory_item_id = t.inventory_item_id
1924: AND b.organization_id = t.organization_id
1925: AND t.LANGUAGE = USERENV ('LANG')

Line 2155: mtl_system_items_tl t

2151: ol.tax_exempt_reason_code,
2152: ol.tax_code, ol.tax_exempt_flag -- End Bug#5008188
2153: FROM oe_order_lines_all ol,
2154: mtl_system_items_b_kfv b,
2155: mtl_system_items_tl t
2156: WHERE ol.line_id = p_order_line_id
2157: AND b.inventory_item_id = ol.inventory_item_id
2158: AND b.inventory_item_id = t.inventory_item_id
2159: AND b.organization_id = t.organization_id

Line 2885: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t

2881: CURSOR l_serv_csr (p_serv_id NUMBER)
2882: IS
2883: SELECT t.description NAME, b.concatenated_segments description,
2884: b.coverage_schedule_id coverage_template_id
2885: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
2886: WHERE b.inventory_item_id = t.inventory_item_id
2887: AND b.organization_id = t.organization_id
2888: AND t.LANGUAGE = USERENV ('LANG')
2889: AND b.inventory_item_id = p_serv_id

Line 3681: mtl_system_items_tl t --okx_system_items_v mtl

3677: b.coverage_schedule_id coverage_template_id
3678: -- mtl.coverage_template_id
3679: FROM csi_item_instances csi,
3680: mtl_system_items_b_kfv b,
3681: mtl_system_items_tl t --okx_system_items_v mtl
3682: WHERE csi.instance_id = p_cpid
3683: AND csi.inventory_item_id = b.inventory_item_id
3684: AND b.inventory_item_id = t.inventory_item_id
3685: AND b.organization_id = t.organization_id