HZ_ADDRESSES_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 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.PARTY_SITE_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.SITE_SOURCE_SYSTEM SOURCE_SYSTEM, P_INT.PARTY_ID FROM HZ_ADDRESSES_INT P_INT WHERE P_INT.IMPORT_STATUS_CODE IS NULL |