APPS.OKS_EXTWARPRGM_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 741: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t

737: */
738: CURSOR l_inv_csr (p_product_item NUMBER)
739: IS
740: SELECT t.description NAME, b.concatenated_segments description
741: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
742: WHERE b.inventory_item_id = t.inventory_item_id
743: AND b.organization_id = t.organization_id
744: AND t.LANGUAGE = USERENV ('LANG')
745: AND b.inventory_item_id = p_product_item

Line 8504: FROM mtl_system_items_tl t

8500: IS
8501: CURSOR l_serv_csr (p_serv_id NUMBER)
8502: IS
8503: SELECT t.description NAME
8504: FROM mtl_system_items_tl t
8505: WHERE t.inventory_item_id = p_serv_id
8506: AND t.LANGUAGE = USERENV ('LANG')
8507: AND ROWNUM < 2;
8508:

Line 9329: FROM mtl_system_items_tl t

9325:
9326: CURSOR l_serv_csr (p_serv_id NUMBER)
9327: IS
9328: SELECT t.description NAME
9329: FROM mtl_system_items_tl t
9330: WHERE t.inventory_item_id = p_serv_id
9331: AND t.LANGUAGE = USERENV ('LANG')
9332: AND ROWNUM < 2;
9333:

Line 10053: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t

10049:
10050: CURSOR l_serv_csr (p_serv_id NUMBER)
10051: IS
10052: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments )
10053: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
10054: WHERE b.inventory_item_id = t.inventory_item_id
10055: AND b.organization_id = t.organization_id
10056: AND t.LANGUAGE = USERENV ('LANG')
10057: AND b.inventory_item_id = p_serv_id

Line 10320: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t

10316:
10317: CURSOR l_serv_csr (p_serv_id NUMBER)
10318: IS
10319: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments )
10320: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
10321: WHERE b.inventory_item_id = t.inventory_item_id
10322: AND b.organization_id = t.organization_id
10323: AND t.LANGUAGE = USERENV ('LANG')
10324: AND b.inventory_item_id = p_serv_id

Line 13891: FROM mtl_system_items_tl t

13887: IS
13888: CURSOR l_serv_csr (p_serv_id NUMBER)
13889: IS
13890: SELECT t.description NAME
13891: FROM mtl_system_items_tl t
13892: WHERE t.inventory_item_id = p_serv_id
13893: AND t.LANGUAGE = USERENV ('LANG')
13894: AND ROWNUM < 2;
13895:

Line 14662: mtl_system_items_tl t,

14658: CURSOR l_serv_csr (p_serv_line_id NUMBER)
14659: IS
14660: SELECT t.description NAME, b.concatenated_segments description
14661: FROM mtl_system_items_b_kfv b,
14662: mtl_system_items_tl t,
14663: okc_k_items ki
14664: WHERE ki.cle_id = p_serv_line_id
14665: AND b.inventory_item_id = TO_CHAR (ki.object1_id1)
14666: AND t.inventory_item_id = b.inventory_item_id