[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT HZ_MATCHED_PARTY_OBJ (
hzp.party_id
,mpgt.score
,hzp.party_number
,hzp.party_name
,hzp.party_type
,hzp.address1
,hzp.address2
,hzp.address3
,hzp.address4
,hzp.city
,hzp.state
,hzp.country
,hzp.primary_phone_country_code
,hzp.primary_phone_area_code
,hzp.primary_phone_number
,hzp.email_address
,CAST (MULTISET (
SELECT HZ_ORIG_SYS_REF_OBJ(
NULL, --P_ACTION_TYPE,
ORIG_SYSTEM_REF_ID,
ORIG_SYSTEM,
ORIG_SYSTEM_REFERENCE,
HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),
OWNER_TABLE_ID,
STATUS,
REASON_CODE,
OLD_ORIG_SYSTEM_REFERENCE,
START_DATE_ACTIVE,
END_DATE_ACTIVE,
PROGRAM_UPDATE_DATE,
CREATED_BY_MODULE,
HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
CREATION_DATE,
LAST_UPDATE_DATE,
HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20)
FROM HZ_ORIG_SYS_REFERENCES OSR
WHERE OSR.OWNER_TABLE_ID = HZP.PARTY_ID
AND OWNER_TABLE_NAME = 'HZ_PARTIES'
AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL)
) AS HZ_MATCHED_PARTY_OBJ_TBL
FROM hz_matched_parties_gt mpgt, hz_parties hzp
WHERE mpgt.party_id = hzp.party_id
AND mpgt.search_context_id = l_search_ctx_id;
SELECT HZ_MATCHED_PARTY_OBJ (
hzp.party_id
,mpgt.score
,hzp.party_number
,hzp.party_name
,hzp.party_type
,hzp.address1
,hzp.address2
,hzp.address3
,hzp.address4
,hzp.city
,hzp.state
,hzp.country
,hzp.primary_phone_country_code
,hzp.primary_phone_area_code
,hzp.primary_phone_number
,hzp.email_address
,CAST (MULTISET (
SELECT HZ_ORIG_SYS_REF_OBJ(
NULL, --P_ACTION_TYPE,
ORIG_SYSTEM_REF_ID,
ORIG_SYSTEM,
ORIG_SYSTEM_REFERENCE,
HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),
OWNER_TABLE_ID,
STATUS,
REASON_CODE,
OLD_ORIG_SYSTEM_REFERENCE,
START_DATE_ACTIVE,
END_DATE_ACTIVE,
PROGRAM_UPDATE_DATE,
CREATED_BY_MODULE,
HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
CREATION_DATE,
LAST_UPDATE_DATE,
HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20)
FROM HZ_ORIG_SYS_REFERENCES OSR
WHERE OSR.OWNER_TABLE_ID = HZP.PARTY_ID
AND OWNER_TABLE_NAME = 'HZ_PARTIES'
AND OSR.ORIG_SYSTEM = l_within_os
AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL)
) AS HZ_MATCHED_PARTY_OBJ_TBL
FROM hz_matched_parties_gt mpgt, hz_parties hzp
WHERE mpgt.party_id = hzp.party_id
AND mpgt.search_context_id = l_search_ctx_id;
l_within_sql := ' EXISTS (SELECT 1 FROM hz_orig_sys_references o
WHERE o.orig_system = '''||p_within_os||'''
AND o.owner_table_name = ''HZ_PARTIES''
AND o.owner_table_id = stage.party_id)';