DBA Data[Home] [Help]

APPS.EAM_MATERIAL_VALIDATE_PUB dependencies on EAM_DIRECT_ITEM_RECS_V

Line 99: FROM eam_direct_item_recs_v

95:
96: CURSOR get_direct_items_csr(p_wip_entity_id NUMBER) IS
97: SELECT NVL(item_description, description) AS item_description,
98: SUM(Get_Open_Qty(required_quantity, quantity_received, 0)) open_quantity
99: FROM eam_direct_item_recs_v
100: WHERE wip_entity_id = p_wip_entity_id
101: GROUP BY item_description, description;
102:
103: CURSOR wip_entity_name_csr(p_wip_entity_id NUMBER) IS