DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on CSP_RS_SUBINVENTORIES_V

Line 275: FROM CSP_RS_SUBINVENTORIES_V csp

271: l_rs_ou number;
272:
273: cursor get_rs_ou(v_rs_type varchar2, v_rs_id number) is
274: SELECT csp.organization_id
275: FROM CSP_RS_SUBINVENTORIES_V csp
276: WHERE csp.resource_type = v_rs_type
277: AND csp.resource_id = v_rs_id
278: AND csp.condition_type = 'G'
279: AND csp.default_flag = 'Y';