[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT HZ_PARTY_SITE_BO(
P_ACTION_TYPE,
NULL, -- COMMON_OBJ_ID
PS.PARTY_SITE_ID,
NULL, --PS.ORIG_SYSTEM,
NULL, --PS.ORIG_SYSTEM_REFERENCE,
HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PS.PARTY_ID),
PS.PARTY_ID,
PS.PARTY_SITE_NUMBER,
PS.MAILSTOP,
PS.IDENTIFYING_ADDRESS_FLAG,
PS.STATUS,
PS.PARTY_SITE_NAME,
PS.ATTRIBUTE_CATEGORY,
PS.ATTRIBUTE1,
PS.ATTRIBUTE2,
PS.ATTRIBUTE3,
PS.ATTRIBUTE4,
PS.ATTRIBUTE5,
PS.ATTRIBUTE6,
PS.ATTRIBUTE7,
PS.ATTRIBUTE8,
PS.ATTRIBUTE9,
PS.ATTRIBUTE10,
PS.ATTRIBUTE11,
PS.ATTRIBUTE12,
PS.ATTRIBUTE13,
PS.ATTRIBUTE14,
PS.ATTRIBUTE15,
PS.ATTRIBUTE16,
PS.ATTRIBUTE17,
PS.ATTRIBUTE18,
PS.ATTRIBUTE19,
PS.ATTRIBUTE20,
PS.LANGUAGE,
PS.ADDRESSEE,
PS.PROGRAM_UPDATE_DATE,
PS.CREATED_BY_MODULE,
HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PS.CREATED_BY),
PS.CREATION_DATE,
PS.LAST_UPDATE_DATE,
HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PS.LAST_UPDATED_BY),
PS.ACTUAL_CONTENT_SOURCE,
PS.GLOBAL_LOCATION_NUMBER,
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 = PS.PARTY_SITE_ID
AND OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
HZ_EXT_ATTRIBUTE_OBJ_TBL(),
HZ_LOCATION_OBJ(
P_ACTION_TYPE,
NULL, -- COMMON_OBJ_ID
LOC.LOCATION_ID,
NULL, --ORIG_SYSTEM,
NULL, --ORIG_SYSTEM_REFERENCE,
LOC.COUNTRY,
LOC.ADDRESS1,
LOC.ADDRESS2,
LOC.ADDRESS3,
LOC.ADDRESS4,
LOC.CITY,
LOC.POSTAL_CODE,
LOC.STATE,
LOC.PROVINCE,
LOC.COUNTY,
LOC.ADDRESS_KEY,
LOC.ADDRESS_STYLE,
LOC.VALIDATED_FLAG,
LOC.ADDRESS_LINES_PHONETIC,
/* LOC.PO_BOX_NUMBER,
LOC.HOUSE_NUMBER,
LOC.STREET_SUFFIX,
LOC.STREET,
LOC.STREET_NUMBER,
LOC.FLOOR,
LOC.SUITE, */
LOC.POSTAL_PLUS4_CODE,
LOC.POSITION,
LOC.LOCATION_DIRECTIONS,
LOC.ADDRESS_EFFECTIVE_DATE,
LOC.ADDRESS_EXPIRATION_DATE,
LOC.CLLI_CODE,
LOC.LANGUAGE,
LOC.SHORT_DESCRIPTION,
LOC.DESCRIPTION,
LOC_HIERARCHY_ID,
LOC.SALES_TAX_GEOCODE,
LOC.SALES_TAX_INSIDE_CITY_LIMITS,
LOC.FA_LOCATION_ID,
LOC.TIMEZONE_ID,
LOC.ATTRIBUTE_CATEGORY,
LOC.ATTRIBUTE1,
LOC.ATTRIBUTE2,
LOC.ATTRIBUTE3,
LOC.ATTRIBUTE4,
LOC.ATTRIBUTE5,
LOC.ATTRIBUTE6,
LOC.ATTRIBUTE7,
LOC.ATTRIBUTE8,
LOC.ATTRIBUTE9,
LOC.ATTRIBUTE10,
LOC.ATTRIBUTE11,
LOC.ATTRIBUTE12,
LOC.ATTRIBUTE13,
LOC.ATTRIBUTE14,
LOC.ATTRIBUTE15,
LOC.ATTRIBUTE16,
LOC.ATTRIBUTE17,
LOC.ATTRIBUTE18,
LOC.ATTRIBUTE19,
LOC.ATTRIBUTE20,
LOC.PROGRAM_UPDATE_DATE,
LOC.CREATED_BY_MODULE,
HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LOC.CREATED_BY),
LOC.CREATION_DATE,
LOC.LAST_UPDATE_DATE,
HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LOC.LAST_UPDATED_BY),
LOC.ACTUAL_CONTENT_SOURCE,
LOC.DELIVERY_POINT_CODE,
LOC.GEOMETRY_STATUS_CODE,
LOC.GEOMETRY,
HZ_ORIG_SYS_REF_OBJ_TBL(),
HZ_EXT_ATTRIBUTE_OBJ_TBL()),
CAST(MULTISET (
SELECT
HZ_PARTY_SITE_USE_OBJ(
P_ACTION_TYPE,
NULL, -- COMMON_OBJ_ID
PARTY_SITE_USE_ID,
COMMENTS,
SITE_USE_TYPE,
PARTY_SITE_ID,
PRIMARY_PER_TYPE,
STATUS,
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))
FROM HZ_PARTY_SITE_USES
WHERE PARTY_SITE_ID = PS.PARTY_SITE_ID) AS HZ_PARTY_SITE_USE_OBJ_TBL),
HZ_PHONE_CP_BO_TBL(),
HZ_TELEX_CP_BO_TBL(),
HZ_EMAIL_CP_BO_TBL(),
HZ_WEB_CP_BO_TBL(),
CAST(MULTISET (
SELECT HZ_CONTACT_PREF_OBJ(
P_ACTION_TYPE,
NULL, -- COMMON_OBJ_ID
CONTACT_PREFERENCE_ID,
'PARTY_SITE',
CONTACT_LEVEL_TABLE_ID,
CONTACT_TYPE,
PREFERENCE_CODE,
PREFERENCE_TOPIC_TYPE,
PREFERENCE_TOPIC_TYPE_ID,
PREFERENCE_TOPIC_TYPE_CODE,
PREFERENCE_START_DATE,
PREFERENCE_END_DATE,
PREFERENCE_START_TIME_HR,
PREFERENCE_END_TIME_HR,
PREFERENCE_START_TIME_MI,
PREFERENCE_END_TIME_MI,
MAX_NO_OF_INTERACTIONS,
MAX_NO_OF_INTERACT_UOM_CODE,
REQUESTED_BY,
REASON_CODE,
STATUS,
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))
FROM HZ_CONTACT_PREFERENCES CPREF
WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTY_SITES'
AND CONTACT_LEVEL_TABLE_ID = PS.PARTY_SITE_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
FROM HZ_PARTY_SITES PS, HZ_LOCATIONS LOC WHERE PS.LOCATION_ID = LOC.LOCATION_ID
AND ((P_PARTY_SITE_ID IS NULL AND PARTY_ID = P_PARTY_ID)
OR (P_PARTY_SITE_ID IS NOT NULL AND PARTY_SITE_ID = P_PARTY_SITE_ID));