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

6892: /*Commented for Bug#14325727 */
6893: /*CURSOR l_serv_csr (p_serv_id NUMBER)
6894: IS
6895: SELECT b.concatenated_segments description
6896: FROM mtl_system_items_b_kfv b
6897: WHERE b.inventory_item_id = p_serv_id AND ROWNUM < 2;
6898: */
6899:
6900: CURSOR l_ordline_csr (p_line_id NUMBER)

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

7765: /*
7766: CURSOR l_serv_csr (p_serv_id NUMBER)
7767: IS
7768: SELECT b.concatenated_segments description
7769: FROM mtl_system_items_b_kfv b
7770: WHERE b.inventory_item_id = p_serv_id AND ROWNUM < 2;
7771: */
7772: CURSOR l_ordline_csr (p_line_id NUMBER)
7773: IS

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

10574:
10575: /* CURSOR l_serv_csr (p_serv_id NUMBER)
10576: IS
10577: SELECT b.concatenated_segments description
10578: FROM mtl_system_items_b_kfv b
10579: WHERE b.inventory_item_id = p_serv_id AND ROWNUM < 2;
10580: */
10581:
10582: l_line_ste_code VARCHAR2 (40);

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

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

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

Line 15811: FROM mtl_system_items_b_kfv b

15807: /*
15808: CURSOR l_serv_csr (p_serv_id NUMBER)
15809: IS
15810: SELECT b.concatenated_segments description
15811: FROM mtl_system_items_b_kfv b
15812: WHERE b.inventory_item_id = p_serv_id AND ROWNUM < 2;
15813: */
15814: CURSOR l_refnum_csr (p_cp_id NUMBER)
15815: IS