eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGI.IGI_CIS_TAX_TREATMENT_H

Object Details

Object Name:	IGI_CIS_TAX_TREATMENT_H
Object Type:	TABLE
Owner:	IGI
Subobject Name:
Status:	VALID

This table stores the changes to the Withholding Tax Group field. This is a history table for audit purposes only.
The changes can occur from the following sources:
1. Supplier window
2. Supplier Site window
3. XML Verification
4. CD-ROM Upload

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
VENDOR_ID	NUMBER	(15)	Yes	Vendor ID
VENDOR_SITE_ID	NUMBER	(15)	Yes	Vendor Site ID
TAX_RATE_ID	NUMBER	(15)	Yes	Tax Rate ID
OLD_GROUP_ID	NUMBER	(15)	Yes	Old Group ID
NEW_GROUP_ID	NUMBER	(15)	Yes	New Group ID
EFFECTIVE_DATE	DATE		Yes	Effective date
SOURCE_NAME	VARCHAR2	(30)	Yes	Source Name
LAST_UPDATE_DATE	DATE		Yes	Standard Who column. The date the user last updated this row
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column. The user who created this row FK to FND_USER.USER_ID
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column. The operating system login of user who last updated this row
CREATION_DATE	DATE		Yes	Standard Who column. The date this row is created
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
REQUEST_ID	NUMBER	(15)		Concurrent program request ID that last updated this row
PROGRAM_ID	NUMBER	(15)		Concurrent program Who column. The program ID that last updated this row
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent program Who column. The application ID of the program that last updated this row.
PROGRAM_UPDATE_DATE	NUMBER	(15)		Concurrent program Who column. The program that last updated this row.
PROGRAM_LOGIN_ID	NUMBER	(15)		Identifies the Oracle Applications concurrent program login ID

Query Text

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


SELECT VENDOR_ID
,      VENDOR_SITE_ID
,      TAX_RATE_ID
,      OLD_GROUP_ID
,      NEW_GROUP_ID
,      EFFECTIVE_DATE
,      SOURCE_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_LOGIN_ID
FROM IGI.IGI_CIS_TAX_TREATMENT_H;

Dependencies

[top of page]

IGI.IGI_CIS_TAX_TREATMENT_H does not reference any database object

IGI.IGI_CIS_TAX_TREATMENT_H is referenced by following:

APPS: IGI_CIS_TAX_TREATMENT_H