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.OKS_EXTWARPRGM_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

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 6716: FROM mtl_system_items_b_kfv b

6712: --bug end 3736860
6713: CURSOR l_serv_csr (p_serv_id NUMBER)
6714: IS
6715: SELECT b.concatenated_segments description
6716: FROM mtl_system_items_b_kfv b
6717: WHERE b.inventory_item_id = p_serv_id AND ROWNUM < 2;
6718:
6719: CURSOR l_ordline_csr (p_line_id NUMBER)
6720: IS

Line 7575: FROM mtl_system_items_b_kfv b

7571: --bug end 3736860
7572: CURSOR l_serv_csr (p_serv_id NUMBER)
7573: IS
7574: SELECT b.concatenated_segments description
7575: FROM mtl_system_items_b_kfv b
7576: WHERE b.inventory_item_id = p_serv_id AND ROWNUM < 2;
7577:
7578: CURSOR l_ordline_csr (p_line_id NUMBER)
7579: IS

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 10330: FROM mtl_system_items_b_kfv b

10326:
10327: /* CURSOR l_serv_csr (p_serv_id NUMBER)
10328: IS
10329: SELECT b.concatenated_segments description
10330: FROM mtl_system_items_b_kfv b
10331: WHERE b.inventory_item_id = p_serv_id AND ROWNUM < 2;
10332: */
10333:
10334: l_line_ste_code VARCHAR2 (40);

Line 14661: FROM mtl_system_items_b_kfv b,

14657: --mmadhavi bug 3761489
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)

Line 15513: FROM mtl_system_items_b_kfv b

15509:
15510: CURSOR l_serv_csr (p_serv_id NUMBER)
15511: IS
15512: SELECT b.concatenated_segments description
15513: FROM mtl_system_items_b_kfv b
15514: WHERE b.inventory_item_id = p_serv_id AND ROWNUM < 2;
15515:
15516: CURSOR l_refnum_csr (p_cp_id NUMBER)
15517: IS