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

TABLE: AP.AP_AWT_GROUP_TAXES_ALL

Object Details
Object Name: AP_AWT_GROUP_TAXES_ALL
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_AWT_GROUP_TAXES_ALL
Subobject Name:
Status: VALID


AP_AWT_GROUP_TAXES_ALL is the intersection
table that belongs to a specific withholding tax
group and refers to a specific withholding tax code. Its
primary key is GROUP_ID and TAX_NAME. The same
withholding tax code cannot belong to the same withholding tax group more than once.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER (15) Yes Withholding Tax group identifier
TAX_NAME VARCHAR2 (15) Yes Withholding tax code
RANK NUMBER (15) Yes The order in which the withholding taxes are to be processed (this affects the amount basis for each progressive tax)
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ORG_ID NUMBER (15)
Organization identifier
Query Text

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


SELECT GROUP_ID
,      TAX_NAME
,      RANK
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ORG_ID
FROM AP.AP_AWT_GROUP_TAXES_ALL;

Dependencies

[top of page]

AP.AP_AWT_GROUP_TAXES_ALL does not reference any database object

AP.AP_AWT_GROUP_TAXES_ALL is referenced by following:

SchemaAPPS
SynonymAP_AWT_GROUP_TAXES
SynonymAP_AWT_GROUP_TAXES_ALL