eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: ZX.ZX_PARTY_TAX_PROFILE_INT#

Source

View Text - Preformatted


select BATCH_ID BATCH_ID, REQUEST_ID REQUEST_ID, DML_TYPE DML_TYPE, INTF_PTP_REFERENCE INTF_PTP_REFERENCE, PARTY_TYPE_CODE PARTY_TYPE_CODE, RECORD_STATUS RECORD_STATUS, INTF_PARTY_REFERENCE INTF_PARTY_REFERENCE, INTF_PARTY_SITE_REFERENCE INTF_PARTY_SITE_REFERENCE, PARTY_ID PARTY_ID, PARTY_NAME PARTY_NAME, ERROR_NUMBER ERROR_NUMBER, PARTY_TAX_PROFILE_ID PARTY_TAX_PROFILE_ID, REGISTRATION_NUMBER REGISTRATION_NUMBER, COUNTRY_CODE COUNTRY_CODE, COUNTRY_NAME COUNTRY_NAME, PROG_INT_CHAR1 PROG_INT_CHAR1, PROG_INT_NUM1 PROG_INT_NUM1, REGISTRATION_TYPE_CODE REGISTRATION_TYPE_CODE, REGISTRATION_TYPE_NAME REGISTRATION_TYPE_NAME, PROCESS_FOR_APPLICABILITY_FLAG PROCESS_FOR_APPLICABILITY_FLAG, ROUNDING_LEVEL_CODE ROUNDING_LEVEL_CODE, ROUNDING_LEVEL_NAME ROUNDING_LEVEL_NAME, ROUNDING_RULE_CODE ROUNDING_RULE_CODE, ROUNDING_RULE_NAME ROUNDING_RULE_NAME, INCLUSIVE_TAX_FLAG INCLUSIVE_TAX_FLAG, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE, TAX_CLASSIFICATION_NAME TAX_CLASSIFICATION_NAME, ALLOW_OFFSET_TAX_FLAG ALLOW_OFFSET_TAX_FLAG from "ZX"."ZX_PARTY_TAX_PROFILE_INT"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, REQUEST_ID REQUEST_ID
, DML_TYPE DML_TYPE
, INTF_PTP_REFERENCE INTF_PTP_REFERENCE
, PARTY_TYPE_CODE PARTY_TYPE_CODE
, RECORD_STATUS RECORD_STATUS
, INTF_PARTY_REFERENCE INTF_PARTY_REFERENCE
, INTF_PARTY_SITE_REFERENCE INTF_PARTY_SITE_REFERENCE
, PARTY_ID PARTY_ID
, PARTY_NAME PARTY_NAME
, ERROR_NUMBER ERROR_NUMBER
, PARTY_TAX_PROFILE_ID PARTY_TAX_PROFILE_ID
, REGISTRATION_NUMBER REGISTRATION_NUMBER
, COUNTRY_CODE COUNTRY_CODE
, COUNTRY_NAME COUNTRY_NAME
, PROG_INT_CHAR1 PROG_INT_CHAR1
, PROG_INT_NUM1 PROG_INT_NUM1
, REGISTRATION_TYPE_CODE REGISTRATION_TYPE_CODE
, REGISTRATION_TYPE_NAME REGISTRATION_TYPE_NAME
, PROCESS_FOR_APPLICABILITY_FLAG PROCESS_FOR_APPLICABILITY_FLAG
, ROUNDING_LEVEL_CODE ROUNDING_LEVEL_CODE
, ROUNDING_LEVEL_NAME ROUNDING_LEVEL_NAME
, ROUNDING_RULE_CODE ROUNDING_RULE_CODE
, ROUNDING_RULE_NAME ROUNDING_RULE_NAME
, INCLUSIVE_TAX_FLAG INCLUSIVE_TAX_FLAG
, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, TAX_CLASSIFICATION_NAME TAX_CLASSIFICATION_NAME
, ALLOW_OFFSET_TAX_FLAG ALLOW_OFFSET_TAX_FLAG
FROM "ZX"."ZX_PARTY_TAX_PROFILE_INT"