APPS.OKS_EXTWAR_UTIL_PVT dependencies on CSI_ITEM_INSTANCES

Line 1004: FROM csi_item_instances csi, oe_order_lines_all ol

1000: SELECT DECODE (ol.actual_shipment_date,
1001: NULL, 'N',
1002: 'Y'
1003: ) shipped_flag
1004: FROM csi_item_instances csi, oe_order_lines_all ol
1005: WHERE csi.instance_id = p_customer_product_id
1006: AND csi.last_oe_order_line_id = ol.line_id;
1007:
1008: /* fix for bug#6047047 -- fp of bug#5939487 */

Line 3679: FROM csi_item_instances csi,

3675: b.concatenated_segments description --mtl.description
3676: ,
3677: b.coverage_schedule_id coverage_template_id
3678: -- mtl.coverage_template_id
3679: FROM csi_item_instances csi,
3680: mtl_system_items_b_kfv b,
3681: mtl_system_items_tl t --okx_system_items_v mtl
3682: WHERE csi.instance_id = p_cpid
3683: AND csi.inventory_item_id = b.inventory_item_id