DBA Data[Home] [Help]

APPS.EAM_MATERIAL_VALIDATE_PUB dependencies on EAM_DIRECT_ITEM_RECS_V

Line 103: FROM eam_direct_item_recs_v

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