HZ_AR_PERSON_INT_SR_V

Details

• Schema: FUSION

• Object owner: HZ

• Object type: VIEW

Columns

Name

ACTION_CODE PROCESS_CODE PROCESS_ID RECORD_DATE RECORD_ID SOURCE_RECORD_ID RECORD_VERSION SOURCE_RECORD_DATE SOURCE_RECORD_VERSION SOURCE_SYSTEM PARTY_NUMBER SALUTATION PERSON_FIRST_NAME PERSON_LAST_NAME PERSON_LAST_NAME_PREFIX PERSON_SECOND_LAST_NAME PERSON_MIDDLE_NAME PERSON_NAME_SUFFIX PERSON_TITLE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30

Query

SQL_Statement

SELECT DECODE(P_INT.ACTION_FLAG, 'I', 'INSERT', 'U', 'UPDATE', P_INT.ACTION_CODE) ACTION_CODE, 'HZ_IMPORT' PROCESS_CODE, P_INT.BATCH_ID PROCESS_ID, (SELECT TO_TIMESTAMP(NULL) FROM DUAL) RECORD_DATE, P_INT.PARTY_ID RECORD_ID, P_INT.PARTY_T_ID SOURCE_RECORD_ID, (SELECT TO_NUMBER(NULL) FROM DUAL) RECORD_VERSION, (SELECT TO_TIMESTAMP(NULL) FROM DUAL) SOURCE_RECORD_DATE, (SELECT TO_NUMBER(NULL) FROM DUAL) SOURCE_RECORD_VERSION, P_INT.PARTY_ORIG_SYSTEM SOURCE_SYSTEM, P_INT.PARTY_NUMBER, P_INT.SALUTATION, P_INT.PERSON_FIRST_NAME, P_INT.PERSON_LAST_NAME, P_INT.PERSON_LAST_NAME_PREFIX, P_INT.PERSON_SECOND_LAST_NAME, P_INT.PERSON_MIDDLE_NAME, P_INT.PERSON_NAME_SUFFIX, P_INT.PERSON_TITLE, P_INT.ATTRIBUTE_CATEGORY, P_INT.ATTRIBUTE1, P_INT.ATTRIBUTE2, P_INT.ATTRIBUTE3, P_INT.ATTRIBUTE4, P_INT.ATTRIBUTE5, P_INT.ATTRIBUTE6, P_INT.ATTRIBUTE7, P_INT.ATTRIBUTE8, P_INT.ATTRIBUTE9, P_INT.ATTRIBUTE10, P_INT.ATTRIBUTE11, P_INT.ATTRIBUTE12, P_INT.ATTRIBUTE13, P_INT.ATTRIBUTE14, P_INT.ATTRIBUTE15, P_INT.ATTRIBUTE16, P_INT.ATTRIBUTE17, P_INT.ATTRIBUTE18, P_INT.ATTRIBUTE19, P_INT.ATTRIBUTE20, P_INT.ATTRIBUTE21, P_INT.ATTRIBUTE22, P_INT.ATTRIBUTE23, P_INT.ATTRIBUTE24, P_INT.ATTRIBUTE25, P_INT.ATTRIBUTE26, P_INT.ATTRIBUTE27, P_INT.ATTRIBUTE28, P_INT.ATTRIBUTE29, P_INT.ATTRIBUTE30 FROM HZ_IMP_PARTIES_T P_INT WHERE P_INT.PARTY_TYPE = 'PERSON' AND P_INT.INTERFACE_STATUS IS NULL