[Home] [Help]
[Dependency Information]
| Object Name: | IGF_AP_TAX |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | IGF.IGF_AP_TAX
|
| Subobject Name: | |
| Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Shows database row id | |
| BASE_ID | NUMBER | (10) | Yes | Identifier for student |
| TAXES_PAID | NUMBER | (12) | Yes | Shows the taxes amont paid by the student |
| AGI | NUMBER | (12) | Yes | Shows the adjusted gross income of the student |
| 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 | |
| ORG_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, BASE_ID
, TAXES_PAID
, AGI
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
FROM APPS.IGF_AP_TAX;
APPS
IGF_AP_TAX_ALL
APPS
IGF_AP_TAX_V
|
|
|
|