[Home] [Help] [Dependency Information]
Object Name: | AP_INCOME_TAX_REGIONS# |
---|---|
Object Type: | VIEW |
Owner: | AP |
Subobject Name: | |
Status: | VALID |
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 |
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#;
|
|
|