SELECT A.ACCESS_ID , B.RS_CUST_RELATION_ID , B.RESOURCE_TYPE , B.RESOURCE_ID , B.CUSTOMER_ID FROM CSP_RS_CUST_RELATIONS B , JTM_CSP_RS_CUST_RELATIONS_ACC A WHERE B.RS_CUST_RELATION_ID = A.RS_CUST_RELATION_ID AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID
SELECT A.ACCESS_ID
, B.RS_CUST_RELATION_ID
, B.RESOURCE_TYPE
, B.RESOURCE_ID
, B.CUSTOMER_ID
FROM CSP_RS_CUST_RELATIONS B
, JTM_CSP_RS_CUST_RELATIONS_ACC A
WHERE B.RS_CUST_RELATION_ID = A.RS_CUST_RELATION_ID
AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID
|
|
|