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

VIEW: JE.JE_IT_ABOVE_THR_HDR_ALL#

Object Details
Object Name: JE_IT_ABOVE_THR_HDR_ALL#
Object Type: VIEW
Owner: JE
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
VAT_REPORTING_ENTITY_ID NUMBER (15) Yes
YEAR_OF_DECLARATION NUMBER (4) Yes
ORG_ID NUMBER (15)
REPORT_MODE VARCHAR2 (1)
TYPE_OF_UPLOAD VARCHAR2 (1)
REQUEST_ID NUMBER (15)
TRANSMISSION_CODE NUMBER (17)
PROVINCE_CODE VARCHAR2 (2)
DECLR_OF_INCORP_COMP NUMBER (1)
TRX_ACCOUNTING_STATUS VARCHAR2 (15)
END_DATE_TO_EXTR_CM_DM DATE

B2C_INVOICE_THRESHOLD NUMBER (10)
B2B_INVOICE_THRESHOLD NUMBER (10)
START_DATE_TO_EXTR_B2C_TRX DATE

NO_OF_DETAILED_RECORDS NUMBER (5)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
PROTOCOL_NUM NUMBER (10)
Query Text

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


SELECT VAT_REPORTING_ENTITY_ID
,      YEAR_OF_DECLARATION
,      ORG_ID
,      REPORT_MODE
,      TYPE_OF_UPLOAD
,      REQUEST_ID
,      TRANSMISSION_CODE
,      PROVINCE_CODE
,      DECLR_OF_INCORP_COMP
,      TRX_ACCOUNTING_STATUS
,      END_DATE_TO_EXTR_CM_DM
,      B2C_INVOICE_THRESHOLD
,      B2B_INVOICE_THRESHOLD
,      START_DATE_TO_EXTR_B2C_TRX
,      NO_OF_DETAILED_RECORDS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      PROTOCOL_NUM
FROM JE.JE_IT_ABOVE_THR_HDR_ALL#;

Dependencies

[top of page]

JE.JE_IT_ABOVE_THR_HDR_ALL# references the following:

SchemaJE
TableJE_IT_ABOVE_THR_HDR_ALL
JE.JE_IT_ABOVE_THR_HDR_ALL# is referenced by following:

SchemaAPPS
SynonymJE_IT_ABOVE_THR_HDR_ALL