HZ_RELSHIPS_PER_INT_SR_V

Details

• Schema: FUSION

• Object owner: HZ

• Object type: VIEW

Columns

Name
ACTION_CODE PROCESS_CODE PROCESS_ID RECORD_DATE RECORD_ID RECORD_VERSION SOURCE_RECORD_DATE SOURCE_RECORD_ID SOURCE_RECORD_VERSION SOURCE_SYSTEM SUBJECT_PARTY_ID

Query

SQL_Statement

SELECT NVL(P_INT.INTERNAL_ACTION_CODE, 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.RELATIONSHIP_ID RECORD_ID, (SELECT TO_NUMBER(NULL) FROM DUAL) RECORD_VERSION, (SELECT TO_TIMESTAMP(NULL) FROM DUAL) SOURCE_RECORD_DATE, P_INT.INTERFACE_ROW_ID SOURCE_RECORD_ID, (SELECT TO_NUMBER(NULL) FROM DUAL) SOURCE_RECORD_VERSION, P_INT.RELATIONSHIP_SOURCE_SYSTEM SOURCE_SYSTEM, P_INT.SUBJECT_PARTY_ID FROM HZ_RELATIONSHIPS_INT P_INT WHERE P_INT.IMPORT_STATUS_CODE IS NULL AND P_INT.SUBJECT_TYPE = 'PERSON'