DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ACCT_CONT_BO_PVT dependencies on HZ_ORIG_SYS_REF_OBJ_TBL

Line 179: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- acct contact ssm

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
180: CAST(MULTISET (
181: SELECT HZ_ORIG_SYS_REF_OBJ(
182: NULL, --P_ACTION_TYPE,
183: OSR.ORIG_SYSTEM_REF_ID,

Line 225: AND OSR.STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- contact person ssm

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'
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