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

VIEW: AP.AP_INCOME_TAX_REGIONS#

Object Details
Object Name: AP_INCOME_TAX_REGIONS#
Object Type: VIEW
Owner: AP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REGION_SHORT_NAME VARCHAR2 (10) Yes
REGION_LONG_NAME VARCHAR2 (25)
REGION_CODE NUMBER (15)
REPORTING_LIMIT NUMBER

NUM_OF_PAYEES NUMBER

CONTROL_TOTAL1 NUMBER

CONTROL_TOTAL2 NUMBER

CONTROL_TOTAL3 NUMBER

CONTROL_TOTAL4 NUMBER

CONTROL_TOTAL5 NUMBER

CONTROL_TOTAL6 NUMBER

CONTROL_TOTAL7 NUMBER

CONTROL_TOTAL8 NUMBER

CONTROL_TOTAL9 NUMBER

CONTROL_TOTAL10 NUMBER

ACTIVE_DATE DATE

INACTIVE_DATE DATE

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
REPORTING_LIMIT_METHOD_CODE VARCHAR2 (25) Yes
CONTROL_TOTAL13 NUMBER

CONTROL_TOTAL13E NUMBER

CONTROL_TOTAL14 NUMBER

CONTROL_TOTAL15A NUMBER

CONTROL_TOTAL15B NUMBER

Query Text

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


SELECT REGION_SHORT_NAME
,      REGION_LONG_NAME
,      REGION_CODE
,      REPORTING_LIMIT
,      NUM_OF_PAYEES
,      CONTROL_TOTAL1
,      CONTROL_TOTAL2
,      CONTROL_TOTAL3
,      CONTROL_TOTAL4
,      CONTROL_TOTAL5
,      CONTROL_TOTAL6
,      CONTROL_TOTAL7
,      CONTROL_TOTAL8
,      CONTROL_TOTAL9
,      CONTROL_TOTAL10
,      ACTIVE_DATE
,      INACTIVE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REPORTING_LIMIT_METHOD_CODE
,      CONTROL_TOTAL13
,      CONTROL_TOTAL13E
,      CONTROL_TOTAL14
,      CONTROL_TOTAL15A
,      CONTROL_TOTAL15B
FROM AP.AP_INCOME_TAX_REGIONS#;

Dependencies

[top of page]

AP.AP_INCOME_TAX_REGIONS# references the following:

SchemaAP
TableAP_INCOME_TAX_REGIONS
AP.AP_INCOME_TAX_REGIONS# is referenced by following:

SchemaAPPS
SynonymAP_INCOME_TAX_REGIONS