[Home] [Help]
[Dependency Information]
| Object Name: | IGF_AP_STATE_TX_RTS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | IGF.IGF_AP_STATE_TX_RTS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
OBSOLETE
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Indicates the Unique Row Identifier | |
| TXRNG_ID | NUMBER | (15) | Yes | Indicates the Unique Tax Range Identifier |
| STATE_CD | VARCHAR2 | (30) | Yes | Indicates the State Code |
| STATE_DESC | VARCHAR2 | (4000) | Indicates the State Description | |
| PERCT | NUMBER | (6) | Yes | Indicates the State Tax Percentage |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| CREATION_DATE | DATE | Yes | Standard WHO Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, TXRNG_ID
, STATE_CD
, STATE_DESC
, PERCT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGF_AP_STATE_TX_RTS_V;
APPS
IGF_AP_STATE_TX_RTS
IGF_AW_GEN
- show dependent code
APPS.IGF_AP_STATE_TX_RTS_V is not referenced by any database object
|
|
|
|