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: JA.JAI_PA_SETUP_VALUES

Object Details

Object Name:	JAI_PA_SETUP_VALUES
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_PA_SETUP_VALUES
Subobject Name:
Status:	VALID

This table is Responsible for Attachemnt of Tax Category with Context Types

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
SETUP_VALUE_ID	NUMBER	(15)	Yes	Setup Header Identifier which is sequence driven
CONTEXT_ID	NUMBER	(15)		Context Identifier
CONTEXT	VARCHAR2	(30)		context Description
ATTRIBUTE1	VARCHAR2	(240)		Attribute1 Identifier
ATTRIBUTE2	VARCHAR2	(240)		Attribute2 Identifier
ATTRIBUTE3	VARCHAR2	(240)		Attribute 3 Identifier
ATTRIBUTE4	VARCHAR2	(240)		Attribute 4 Identifier
ATTRIBUTE5	VARCHAR2	(240)		Attribute 5 Identifier
SETUP_VALUE1	VARCHAR2	(240)		Setup Value 1 Identifier
SETUP_VALUE2	VARCHAR2	(240)		Setup Value 2 Identifier
SETUP_VALUE3	VARCHAR2	(240)		Setup Value 3 Identifier
SETUP_VALUE4	VARCHAR2	(240)		Setup Value 4 Identifier
SETUP_VALUE5	VARCHAR2	(240)		Setup Value 5 Identifier
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER			Standard Who column
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number

Query Text

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


SELECT SETUP_VALUE_ID
,      CONTEXT_ID
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      SETUP_VALUE1
,      SETUP_VALUE2
,      SETUP_VALUE3
,      SETUP_VALUE4
,      SETUP_VALUE5
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_PA_SETUP_VALUES;

Dependencies

[top of page]

JA.JAI_PA_SETUP_VALUES does not reference any database object

JA.JAI_PA_SETUP_VALUES is referenced by following:

APPS: JAI_PA_SETUP_VALUES