DBA Data[Home] [Help]

APPS.OKS_MISC_UTIL_WEB dependencies on OKC_K_ITEMS

Line 927: ,okc_k_items itm

923: CURSOR get_prod_name_csr IS
924: SELECT decode(fnd_profile.value('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC'
925: , mtl.description,mtl.concatenated_segments)
926: FROM mtl_system_items_kfv mtl
927: ,okc_k_items itm
928: ,csi_item_instances csi
929: WHERE itm.object1_id1 = p_object1_id1
930: AND itm.jtot_object1_code = p_jtot_object1_code
931: AND csi.instance_id = itm.object1_id1

Line 1054: FROM OKC_K_ITEMS

1050: CURSOR get_objec_rel_csr(p_line_id NUMBER) IS
1051: SELECT jtot_object1_code,
1052: object1_id1,
1053: object1_id2
1054: FROM OKC_K_ITEMS
1055: WHERE CLE_ID = p_line_id;
1056:
1057: CURSOR get_name_csr (p_object1_id1 VARCHAR2) IS
1058: SELECT fnd_flex_server.get_kfv_concat_segs_by_rowid('COMPACT', 401, 'SERV', 101, sysitems.rowid)name

Line 1164: FROM okc_k_items itm

1160: 'N'
1161: ELSE
1162: 'Y'
1163: END) isComponentFlag
1164: FROM okc_k_items itm
1165: ,csi_item_instances csi
1166: ,oe_order_lines_all oel
1167: ,oe_order_lines_all oel1
1168: ,(SELECT rel.object1_id1,