APPS.OKS_EXTWAR_UTIL_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 1925: mtl_system_items_tl t

1921: IS
1922: SELECT t.description NAME,
1923: b.concatenated_segments description
1924: FROM mtl_system_items_b_kfv b,
1925: mtl_system_items_tl t
1926: WHERE
1927: b.inventory_item_id = t.inventory_item_id
1928: AND b.organization_id = t.organization_id
1929: AND t.LANGUAGE = USERENV ('LANG')

Line 2160: mtl_system_items_tl t

2156: ol.tax_code, ol.tax_exempt_flag, -- End Bug#5008188
2157: b.contract_item_type_code ----Added for ER 16039680
2158: FROM oe_order_lines_all ol,
2159: mtl_system_items_b_kfv b,
2160: mtl_system_items_tl t
2161: WHERE ol.line_id = p_order_line_id
2162: AND b.inventory_item_id = ol.inventory_item_id
2163: AND b.inventory_item_id = t.inventory_item_id
2164: AND b.organization_id = t.organization_id

Line 2931: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t

2927: CURSOR l_serv_csr (p_serv_id NUMBER)
2928: IS
2929: SELECT t.description NAME, b.concatenated_segments description,
2930: b.coverage_schedule_id coverage_template_id
2931: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
2932: WHERE b.inventory_item_id = t.inventory_item_id
2933: AND b.organization_id = t.organization_id
2934: AND t.LANGUAGE = USERENV ('LANG')
2935: AND b.inventory_item_id = p_serv_id

Line 3727: mtl_system_items_tl t --okx_system_items_v mtl

3723: b.coverage_schedule_id coverage_template_id
3724: -- mtl.coverage_template_id
3725: FROM csi_item_instances csi,
3726: mtl_system_items_b_kfv b,
3727: mtl_system_items_tl t --okx_system_items_v mtl
3728: WHERE csi.instance_id = p_cpid
3729: AND csi.inventory_item_id = b.inventory_item_id
3730: AND b.inventory_item_id = t.inventory_item_id
3731: AND b.organization_id = t.organization_id