61:
62: Embedded TCA Entity Mandatory Multiple TCA Table Entities
63:
64: Customer Account Role N N HZ_CUST_ACCOUNT_ROLES
65: Role Responsibility N Y HZ_ROLE_RESPONSIBILITY
66:
67: */
68:
69:
223: AND R.SUBJECT_TYPE = 'PERSON'
224: AND OSR.OWNER_TABLE_NAME = 'HZ_PARTIES'
225: AND OSR.STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- contact person ssm
226: CAST(MULTISET (
227: SELECT HZ_ROLE_RESPONSIBILITY_OBJ(
228: P_ACTION_TYPE,
229: NULL, --COMMON_OBJ_ID
230: RESPONSIBILITY_ID,
231: CUST_ACCOUNT_ROLE_ID,
252: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
253: CREATION_DATE,
254: LAST_UPDATE_DATE,
255: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
256: FROM HZ_ROLE_RESPONSIBILITY
257: WHERE CUST_ACCOUNT_ROLE_ID = CAR.CUST_ACCOUNT_ROLE_ID) AS HZ_ROLE_RESPONSIBILITY_OBJ_TBL))
258: FROM HZ_CUST_ACCOUNT_ROLES CAR, HZ_CUST_ACCOUNTS CA, HZ_RELATIONSHIPS R
259: WHERE
260: R.PARTY_ID = CAR.PARTY_ID
253: CREATION_DATE,
254: LAST_UPDATE_DATE,
255: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
256: FROM HZ_ROLE_RESPONSIBILITY
257: WHERE CUST_ACCOUNT_ROLE_ID = CAR.CUST_ACCOUNT_ROLE_ID) AS HZ_ROLE_RESPONSIBILITY_OBJ_TBL))
258: FROM HZ_CUST_ACCOUNT_ROLES CAR, HZ_CUST_ACCOUNTS CA, HZ_RELATIONSHIPS R
259: WHERE
260: R.PARTY_ID = CAR.PARTY_ID
261: AND CA.PARTY_ID = R.OBJECT_ID