DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ACCT_CONT_BO_PVT dependencies on HZ_ORIG_SYS_REFERENCES

Line 175: FROM HZ_ORIG_SYS_REFERENCES OSR

171: ATTRIBUTE17,
172: ATTRIBUTE18,
173: ATTRIBUTE19,
174: ATTRIBUTE20)
175: FROM HZ_ORIG_SYS_REFERENCES OSR
176: WHERE
177: OSR.OWNER_TABLE_ID = CAR.CUST_ACCOUNT_ROLE_ID
178: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNT_ROLES'
179: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- acct contact ssm

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'