APPS.HZ_EXTRACT_CUST_ACCT_BO_PVT dependencies on HZ_ORIG_SYS_REF_OBJ

Line 63: SELECT HZ_ORIG_SYS_REF_OBJ(

59: CREATION_DATE,
60: LAST_UPDATE_DATE,
61: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
62: CAST(MULTISET (
63: SELECT HZ_ORIG_SYS_REF_OBJ(
64: NULL, --P_ACTION_TYPE,
65: ORIG_SYSTEM_REF_ID,
66: ORIG_SYSTEM,
67: ORIG_SYSTEM_REFERENCE,

Line 106: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL))

102: FROM HZ_ORIG_SYS_REFERENCES
103: WHERE
104: OWNER_TABLE_ID = RELATED_CUST_ACCOUNT_ID
105: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
106: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL))
107: FROM HZ_CUST_ACCT_RELATE
108: WHERE CUST_ACCOUNT_ID = P_CUST_ACCT_ID;
109:
110: BEGIN

Line 734: SELECT HZ_ORIG_SYS_REF_OBJ(

730: CA.CREATION_DATE,
731: CA.LAST_UPDATE_DATE,
732: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CA.LAST_UPDATED_BY),
733: CAST(MULTISET (
734: SELECT HZ_ORIG_SYS_REF_OBJ(
735: NULL, --P_ACTION_TYPE,
736: ORIG_SYSTEM_REF_ID,
737: ORIG_SYSTEM,
738: ORIG_SYSTEM_REFERENCE,

Line 777: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),

773: FROM HZ_ORIG_SYS_REFERENCES OSR
774: WHERE
775: OSR.OWNER_TABLE_ID = CA.CUST_ACCOUNT_ID
776: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
777: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
778: HZ_CUST_ACCT_RELATE_OBJ_TBL(),
779: HZ_CUST_ACCT_SITE_BO_TBL(),
780: HZ_CUST_ACCT_CONTACT_BO_TBL(),
781: NULL, --CUST_PROFILE_OBJ,

Line 1194: SELECT HZ_ORIG_SYS_REF_OBJ(

1190: CA.CREATION_DATE,
1191: CA.LAST_UPDATE_DATE,
1192: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CA.LAST_UPDATED_BY),
1193: CAST(MULTISET (
1194: SELECT HZ_ORIG_SYS_REF_OBJ(
1195: NULL, --P_ACTION_TYPE,
1196: ORIG_SYSTEM_REF_ID,
1197: ORIG_SYSTEM,
1198: ORIG_SYSTEM_REFERENCE,

Line 1237: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),

1233: FROM HZ_ORIG_SYS_REFERENCES OSR
1234: WHERE
1235: OSR.OWNER_TABLE_ID = CA.CUST_ACCOUNT_ID
1236: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
1237: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
1238: HZ_CUST_ACCT_RELATE_OBJ_TBL(),
1239: HZ_CUST_ACCT_SITE_V2_BO_TBL(),
1240: HZ_CUST_ACCT_CONTACT_BO_TBL(),
1241: NULL, --CUST_PROFILE_OBJ,