DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ACCT_CONT_BO_PVT dependencies on HZ_RELATIONSHIPS

Line 220: FROM HZ_ORIG_SYS_REFERENCES OSR, HZ_RELATIONSHIPS R

216: OSR.ATTRIBUTE17,
217: OSR.ATTRIBUTE18,
218: OSR.ATTRIBUTE19,
219: OSR.ATTRIBUTE20)
220: FROM HZ_ORIG_SYS_REFERENCES OSR, HZ_RELATIONSHIPS R
221: WHERE OSR.OWNER_TABLE_ID = R.SUBJECT_ID
222: AND CAR.PARTY_ID = R.PARTY_ID
223: AND R.SUBJECT_TYPE = 'PERSON'
224: AND OSR.OWNER_TABLE_NAME = 'HZ_PARTIES'

Line 258: FROM HZ_CUST_ACCOUNT_ROLES CAR, HZ_CUST_ACCOUNTS CA, HZ_RELATIONSHIPS R

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
262: AND CAR.CUST_ACCOUNT_ID = CA.CUST_ACCOUNT_ID