APPS.CSP_PARTS_REQUIREMENT dependencies on CSP_RS_SUBINVENTORIES_V

Line 2887: FROM CSP_RS_SUBINVENTORIES_V csp

2883: and task_assignment_id = v_task_assignment_id;
2884:
2885: cursor get_rs_ou(v_rs_type varchar2, v_rs_id number) is
2886: SELECT csp.organization_id
2887: FROM CSP_RS_SUBINVENTORIES_V csp
2888: WHERE csp.resource_type = v_rs_type
2889: AND csp.resource_id = v_rs_id
2890: AND csp.condition_type = 'G'
2891: AND csp.default_flag = 'Y';