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_TL

Line 781: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t

777: */
778: CURSOR l_inv_csr (p_product_item NUMBER)
779: IS
780: SELECT t.description NAME, b.concatenated_segments description
781: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
782: WHERE b.inventory_item_id = t.inventory_item_id
783: AND b.organization_id = t.organization_id
784: AND t.LANGUAGE = USERENV ('LANG')
785: AND b.inventory_item_id = p_product_item

Line 6885: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t

6881: /* Added for Bug#14325727 */
6882: CURSOR l_serv_csr (p_serv_id NUMBER)
6883: IS
6884: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments) description
6885: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
6886: WHERE b.inventory_item_id = t.inventory_item_id
6887: AND b.organization_id = t.organization_id
6888: AND t.LANGUAGE = USERENV ('LANG')
6889: AND b.inventory_item_id = p_serv_id

Line 7757: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t

7753: /* Added for Bug#14325727 */
7754: CURSOR l_serv_csr (p_serv_id NUMBER)
7755: IS
7756: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments) description
7757: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
7758: WHERE b.inventory_item_id = t.inventory_item_id
7759: AND b.organization_id = t.organization_id
7760: AND t.LANGUAGE = USERENV ('LANG')
7761: AND b.inventory_item_id = p_serv_id

Line 8723: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t

8719: /* Added for Bug#14325727 */
8720: CURSOR l_serv_csr (p_serv_id NUMBER)
8721: IS
8722: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments) description
8723: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
8724: WHERE b.inventory_item_id = t.inventory_item_id
8725: AND b.organization_id = t.organization_id
8726: AND t.LANGUAGE = USERENV ('LANG')
8727: AND b.inventory_item_id = p_serv_id

Line 8734: FROM mtl_system_items_tl t

8730: /*Commented for Bug#14325727 */
8731: /*CURSOR l_serv_csr (p_serv_id NUMBER)
8732: IS
8733: SELECT t.description NAME
8734: FROM mtl_system_items_tl t
8735: WHERE t.inventory_item_id = p_serv_id
8736: AND t.LANGUAGE = USERENV ('LANG')
8737: AND ROWNUM < 2;
8738: */

Line 9560: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t

9556: /* Added for Bug#14325727 */
9557: CURSOR l_serv_csr (p_serv_id NUMBER)
9558: IS
9559: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments) description
9560: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
9561: WHERE b.inventory_item_id = t.inventory_item_id
9562: AND b.organization_id = t.organization_id
9563: AND t.LANGUAGE = USERENV ('LANG')
9564: AND b.inventory_item_id = p_serv_id

Line 9572: FROM mtl_system_items_tl t

9568: /*
9569: CURSOR l_serv_csr (p_serv_id NUMBER)
9570: IS
9571: SELECT t.description NAME
9572: FROM mtl_system_items_tl t
9573: WHERE t.inventory_item_id = p_serv_id
9574: AND t.LANGUAGE = USERENV ('LANG')
9575: AND ROWNUM < 2;
9576: */

Line 10301: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t

10297:
10298: CURSOR l_serv_csr (p_serv_id NUMBER)
10299: IS
10300: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments )
10301: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
10302: WHERE b.inventory_item_id = t.inventory_item_id
10303: AND b.organization_id = t.organization_id
10304: AND t.LANGUAGE = USERENV ('LANG')
10305: AND b.inventory_item_id = p_serv_id

Line 10568: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t

10564:
10565: CURSOR l_serv_csr (p_serv_id NUMBER)
10566: IS
10567: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments )
10568: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
10569: WHERE b.inventory_item_id = t.inventory_item_id
10570: AND b.organization_id = t.organization_id
10571: AND t.LANGUAGE = USERENV ('LANG')
10572: AND b.inventory_item_id = p_serv_id

Line 14163: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t

14159: /* Added for Bug#14325727 */
14160: CURSOR l_serv_csr (p_serv_id NUMBER)
14161: IS
14162: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments) description
14163: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
14164: WHERE b.inventory_item_id = t.inventory_item_id
14165: AND b.organization_id = t.organization_id
14166: AND t.LANGUAGE = USERENV ('LANG')
14167: AND b.inventory_item_id = p_serv_id

Line 14175: FROM mtl_system_items_tl t

14171: /*
14172: CURSOR l_serv_csr (p_serv_id NUMBER)
14173: IS
14174: SELECT t.description NAME
14175: FROM mtl_system_items_tl t
14176: WHERE t.inventory_item_id = p_serv_id
14177: AND t.LANGUAGE = USERENV ('LANG')
14178: AND ROWNUM < 2;
14179: */

Line 14947: mtl_system_items_tl t,

14943: CURSOR l_serv_csr (p_serv_line_id NUMBER)
14944: IS
14945: SELECT t.description NAME, b.concatenated_segments description
14946: FROM mtl_system_items_b_kfv b,
14947: mtl_system_items_tl t,
14948: okc_k_items ki
14949: WHERE ki.cle_id = p_serv_line_id
14950: AND b.inventory_item_id = TO_CHAR (ki.object1_id1)
14951: AND t.inventory_item_id = b.inventory_item_id

Line 15799: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t

15795: /* Added for Bug#14325727 */
15796: CURSOR l_serv_csr (p_serv_id NUMBER)
15797: IS
15798: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments) description
15799: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
15800: WHERE b.inventory_item_id = t.inventory_item_id
15801: AND b.organization_id = t.organization_id
15802: AND t.LANGUAGE = USERENV ('LANG')
15803: AND b.inventory_item_id = p_serv_id