APPS.CSP_PORTAL_EXCESS_PARTS_PVT dependencies on CSP_RS_SUBINVENTORIES_V

Line 27: from csp_rs_subinventories_v

23:
24: Cursor subinv(p_resource_id NUMBER, p_resource_type VARCHAR2, p_condition_type VARCHAR2)
25: is
26: select distinct organization_id,subinventory_code secondary_inventory_name,condition_type
27: from csp_rs_subinventories_v
28: where owner_resource_id = p_resource_id and
29: owner_resource_type = p_resource_type and
30: condition_type = p_condition_type and
31: (EFFECTIVE_DATE_END is null or trunc(EFFECTIVE_DATE_END) > trunc(sysdate));