DBA Data[Home] [Help] [Dependency Information]

VIEW: ZX.ZX_REGISTRATIONS_INT#

Object Details
Object Name: ZX_REGISTRATIONS_INT#
Object Type: VIEW
Owner: ZX
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (22)
REQUEST_ID NUMBER (22)
DML_TYPE VARCHAR2 (10) Yes
INTF_PTP_REFERENCE VARCHAR2 (40) Yes
RECORD_STATUS NUMBER (2)
PARTY_TAX_PROFILE_ID NUMBER (22)
ERROR_NUMBER NUMBER (22)
PROG_INT_RECORD_REF NUMBER (22)
PROG_INT_CHAR1 VARCHAR2 (30)
PROG_INT_NUM1 NUMBER (22)
REGISTRATION_ID NUMBER (22)
REGISTRATION_TYPE_CODE VARCHAR2 (30)
REGISTRATION_TYPE_NAME VARCHAR2 (80)
REGISTRATION_NUMBER VARCHAR2 (50)
ROUNDING_RULE_CODE VARCHAR2 (30)
ROUNDING_RULE_NAME VARCHAR2 (80)
TAX_JURISDICTION_CODE VARCHAR2 (30)
TAX_JURISDICTION_NAME VARCHAR2 (240)
REGISTRATION_STATUS_CODE VARCHAR2 (30)
REGISTRATION_STATUS_NAME VARCHAR2 (80)
REGISTRATION_SOURCE_CODE VARCHAR2 (30)
REGISTRATION_SOURCE_NAME VARCHAR2 (80)
REGISTRATION_REASON_CODE VARCHAR2 (30)
REGISTRATION_REASON_NAME VARCHAR2 (80)
TAX_REGIME_CODE VARCHAR2 (30)
TAX_REGIME_NAME VARCHAR2 (80)
TAX_CODE VARCHAR2 (30)
TAX_NAME VARCHAR2 (80)
INCLUSIVE_TAX_FLAG VARCHAR2 (1)
EFFECTIVE_FROM DATE
Yes
EFFECTIVE_TO DATE

DEFAULT_REGISTRATION_FLAG VARCHAR2 (1)
LEGAL_LOCATION_ID NUMBER (22)
LEGAL_LOCATION_CODE VARCHAR2 (60)
ADDRESS_LINE_1 VARCHAR2 (240)
TOWN_OR_CITY VARCHAR2 (30)
REGION_1 VARCHAR2 (120)
TAX_AUTHORITY_ID NUMBER (22)
TAX_AUTHORITY_NAME VARCHAR2 (360)
LEGAL_REGISTRATION_ID NUMBER (22)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BATCH_ID
,      REQUEST_ID
,      DML_TYPE
,      INTF_PTP_REFERENCE
,      RECORD_STATUS
,      PARTY_TAX_PROFILE_ID
,      ERROR_NUMBER
,      PROG_INT_RECORD_REF
,      PROG_INT_CHAR1
,      PROG_INT_NUM1
,      REGISTRATION_ID
,      REGISTRATION_TYPE_CODE
,      REGISTRATION_TYPE_NAME
,      REGISTRATION_NUMBER
,      ROUNDING_RULE_CODE
,      ROUNDING_RULE_NAME
,      TAX_JURISDICTION_CODE
,      TAX_JURISDICTION_NAME
,      REGISTRATION_STATUS_CODE
,      REGISTRATION_STATUS_NAME
,      REGISTRATION_SOURCE_CODE
,      REGISTRATION_SOURCE_NAME
,      REGISTRATION_REASON_CODE
,      REGISTRATION_REASON_NAME
,      TAX_REGIME_CODE
,      TAX_REGIME_NAME
,      TAX_CODE
,      TAX_NAME
,      INCLUSIVE_TAX_FLAG
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      DEFAULT_REGISTRATION_FLAG
,      LEGAL_LOCATION_ID
,      LEGAL_LOCATION_CODE
,      ADDRESS_LINE_1
,      TOWN_OR_CITY
,      REGION_1
,      TAX_AUTHORITY_ID
,      TAX_AUTHORITY_NAME
,      LEGAL_REGISTRATION_ID
FROM ZX.ZX_REGISTRATIONS_INT#;

Dependencies

[top of page]

ZX.ZX_REGISTRATIONS_INT# references the following:

SchemaZX
TableZX_REGISTRATIONS_INT
ZX.ZX_REGISTRATIONS_INT# is referenced by following:

SchemaAPPS
SynonymZX_REGISTRATIONS_INT