DBA Data[Home] [Help]

APPS.OKS_MISC_UTIL_WEB dependencies on CSI_ITEM_INSTANCES

Line 928: ,csi_item_instances csi

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
932: AND csi.inventory_item_id = mtl.inventory_item_id

Line 1165: ,csi_item_instances csi

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,
1169: rel.cle_id