VIEW: ZX.ZX_REPORT_CODES_ASSOC_INT#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, REQUEST_ID REQUEST_ID, INTF_PTP_REFERENCE INTF_PTP_REFERENCE, DML_TYPE DML_TYPE, RECORD_STATUS RECORD_STATUS, ERROR_NUMBER ERROR_NUMBER, PARTY_TAX_PROFILE_ID PARTY_TAX_PROFILE_ID, PROG_INT_RECORD_REF PROG_INT_RECORD_REF, PROG_INT_CHAR1 PROG_INT_CHAR1, PROG_INT_NUM1 PROG_INT_NUM1, REPORTING_CODE_ASSOC_ID REPORTING_CODE_ASSOC_ID, ENTITY_CODE ENTITY_CODE, ENTITY_ID ENTITY_ID, EFFECTIVE_FROM EFFECTIVE_FROM, EFFECTIVE_TO EFFECTIVE_TO, REPORTING_TYPE_ID REPORTING_TYPE_ID, REPORTING_TYPE_NAME REPORTING_TYPE_NAME, REPORTING_CODE_ID REPORTING_CODE_ID, REPORTING_CODE_NAME REPORTING_CODE_NAME, REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE, REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE, REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE from "ZX"."ZX_REPORT_CODES_ASSOC_INT"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, REQUEST_ID REQUEST_ID
, INTF_PTP_REFERENCE INTF_PTP_REFERENCE
, DML_TYPE DML_TYPE
, RECORD_STATUS RECORD_STATUS
, ERROR_NUMBER ERROR_NUMBER
, PARTY_TAX_PROFILE_ID PARTY_TAX_PROFILE_ID
, PROG_INT_RECORD_REF PROG_INT_RECORD_REF
, PROG_INT_CHAR1 PROG_INT_CHAR1
, PROG_INT_NUM1 PROG_INT_NUM1
, REPORTING_CODE_ASSOC_ID REPORTING_CODE_ASSOC_ID
, ENTITY_CODE ENTITY_CODE
, ENTITY_ID ENTITY_ID
, EFFECTIVE_FROM EFFECTIVE_FROM
, EFFECTIVE_TO EFFECTIVE_TO
, REPORTING_TYPE_ID REPORTING_TYPE_ID
, REPORTING_TYPE_NAME REPORTING_TYPE_NAME
, REPORTING_CODE_ID REPORTING_CODE_ID
, REPORTING_CODE_NAME REPORTING_CODE_NAME
, REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE
, REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE
, REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
FROM "ZX"."ZX_REPORT_CODES_ASSOC_INT"