[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT HZ_RELATIONSHIP_OBJ(
P_ACTION_TYPE,
NULL, -- COMMON_OBJ_ID
RELATIONSHIP_ID,
DECODE(SUBJECT_TYPE, 'ORGANIZATION', 'ORG', SUBJECT_TYPE),
P_SUBJECT_ID,
OBJECT_ID,
DECODE(OBJECT_TYPE, 'ORGANIZATION', 'ORG', OBJECT_TYPE),
NULL, --OBJECT_ORIG_SYSTEM_REFERENCE,
NULL, --OBJECT_ORIG_SYSTEM,
RELATIONSHIP_CODE,
RELATIONSHIP_TYPE,
COMMENTS,
START_DATE,
END_DATE,
STATUS,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
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),
ADDITIONAL_INFORMATION1,
ADDITIONAL_INFORMATION2,
ADDITIONAL_INFORMATION3,
ADDITIONAL_INFORMATION4,
ADDITIONAL_INFORMATION5,
ADDITIONAL_INFORMATION6,
ADDITIONAL_INFORMATION7,
ADDITIONAL_INFORMATION8,
ADDITIONAL_INFORMATION9,
ADDITIONAL_INFORMATION10,
ADDITIONAL_INFORMATION11,
ADDITIONAL_INFORMATION12,
ADDITIONAL_INFORMATION13,
ADDITIONAL_INFORMATION14,
ADDITIONAL_INFORMATION15,
ADDITIONAL_INFORMATION16,
ADDITIONAL_INFORMATION17,
ADDITIONAL_INFORMATION18,
ADDITIONAL_INFORMATION19,
ADDITIONAL_INFORMATION20,
ADDITIONAL_INFORMATION21,
ADDITIONAL_INFORMATION22,
ADDITIONAL_INFORMATION23,
ADDITIONAL_INFORMATION24,
ADDITIONAL_INFORMATION25,
ADDITIONAL_INFORMATION26,
ADDITIONAL_INFORMATION27,
ADDITIONAL_INFORMATION28,
ADDITIONAL_INFORMATION29,
ADDITIONAL_INFORMATION30,
PERCENTAGE_OWNERSHIP,
ACTUAL_CONTENT_SOURCE,
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 = REL.OBJECT_ID
AND OWNER_TABLE_NAME = 'HZ_PARTIES'
AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL))
FROM HZ_RELATIONSHIPS REL
WHERE SUBJECT_ID = P_SUBJECT_ID
AND SUBJECT_TABLE_NAME = 'HZ_PARTIES';