[Home] [Help]
99:
100: CURSOR get_direct_items_csr(p_wip_entity_id NUMBER) IS
101: SELECT NVL(escapeXMLEam(item_description),escapeXMLEam(description)) AS item_description,
102: SUM(Get_Open_Qty(required_quantity, quantity_received, 0)) open_quantity
103: FROM eam_direct_item_recs_v
104: WHERE wip_entity_id = p_wip_entity_id
105: GROUP BY item_description, description;
106:
107: CURSOR wip_entity_name_csr(p_wip_entity_id NUMBER) IS