ZX_PARTY_TAX_PROFILE_STG

Details

Schema: FUSION
Object owner: ZX
Object type: VIEW

Columns

Name
ALLOW_OFFSET_TAX_FLAG BATCH_NAME COUNTRY_CODE CREATED_BY CREATION_DATE CUSTOMER_FLAG INCLUSIVE_TAX_FLAG JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN LOAD_REQUEST_ID LOAD_STATUS OBJECT_VERSION_NUMBER PARTY_NAME PARTY_NUMBER PARTY_TYPE_CODE PROCESS_FOR_APPLICABILITY_FLAG RECORD_STATUS REGISTRATION_TYPE_CODE REP_REGISTRATION_NUMBER REQUEST_ID ROUNDING_LEVEL_CODE ROUNDING_RULE_CODE SUPPLIER_FLAG TAX_CLASSIFICATION_CODE TRANSPORT_PRVDR_FLAG

Name

ALLOW_OFFSET_TAX_FLAG

BATCH_NAME

COUNTRY_CODE

CREATED_BY

CREATION_DATE

CUSTOMER_FLAG

INCLUSIVE_TAX_FLAG

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LOAD_REQUEST_ID

LOAD_STATUS

OBJECT_VERSION_NUMBER

PARTY_NAME

PARTY_NUMBER

PARTY_TYPE_CODE

PROCESS_FOR_APPLICABILITY_FLAG

RECORD_STATUS

REGISTRATION_TYPE_CODE

REP_REGISTRATION_NUMBER

REQUEST_ID

ROUNDING_LEVEL_CODE

ROUNDING_RULE_CODE

SUPPLIER_FLAG

TAX_CLASSIFICATION_CODE

TRANSPORT_PRVDR_FLAG

Query

SQL_Statement
SELECT "ALLOW_OFFSET_TAX_FLAG","BATCH_NAME","COUNTRY_CODE","CREATED_BY","CREATION_DATE","CUSTOMER_FLAG","INCLUSIVE_TAX_FLAG","JOB_DEFINITION_NAME","JOB_DEFINITION_PACKAGE","LAST_UPDATED_BY","LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","LOAD_REQUEST_ID","LOAD_STATUS","OBJECT_VERSION_NUMBER","PARTY_NAME","PARTY_NUMBER","PARTY_TYPE_CODE","PROCESS_FOR_APPLICABILITY_FLAG","RECORD_STATUS","REGISTRATION_TYPE_CODE",NVL2("REP_REGISTRATION_NUMBER",'Secure',NULL) AS "REP_REGISTRATION_NUMBER","REQUEST_ID","ROUNDING_LEVEL_CODE","ROUNDING_RULE_CODE","SUPPLIER_FLAG","TAX_CLASSIFICATION_CODE","TRANSPORT_PRVDR_FLAG" FROM "ZX_PARTY_TAX_PROFILE_STG"

SQL_Statement

SELECT "ALLOW_OFFSET_TAX_FLAG","BATCH_NAME","COUNTRY_CODE","CREATED_BY","CREATION_DATE","CUSTOMER_FLAG","INCLUSIVE_TAX_FLAG","JOB_DEFINITION_NAME","JOB_DEFINITION_PACKAGE","LAST_UPDATED_BY","LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","LOAD_REQUEST_ID","LOAD_STATUS","OBJECT_VERSION_NUMBER","PARTY_NAME","PARTY_NUMBER","PARTY_TYPE_CODE","PROCESS_FOR_APPLICABILITY_FLAG","RECORD_STATUS","REGISTRATION_TYPE_CODE",NVL2("REP_REGISTRATION_NUMBER",'Secure',NULL) AS "REP_REGISTRATION_NUMBER","REQUEST_ID","ROUNDING_LEVEL_CODE","ROUNDING_RULE_CODE","SUPPLIER_FLAG","TAX_CLASSIFICATION_CODE","TRANSPORT_PRVDR_FLAG" FROM "ZX_PARTY_TAX_PROFILE_STG"