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_AP_TDS_CERT_NUMS

Object Details

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

Stores the combination of Legal entity, financial year, Operating Unit, Org_tan_num and certificate_id whenever TDS year info is defined.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AP_TDS_CERT_NUMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEGAL_ENTITY FIN_YR ORG_TAN_NUM CERTIFICATE_NUM LINE_NUM
JAI_AP_TDS_CERT_NUMS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID LEGAL_ENTITY FIN_YR
JAI_AP_TDS_CERT_NUMS_PK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FIN_YR_CERT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER			Organization identifier.This column is not used.
LEGAL_ENTITY	NUMBER			Legal entity identifier.This column is not used.
FIN_YR	NUMBER	(9)		Financial Year.
ORG_TAN_NUM	VARCHAR2	(50)		Organization TAN number
FIN_YR_CERT_ID	NUMBER	(15)	Yes	Financial year certificate identifier
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
CERTIFICATE_NUM	NUMBER	(15)		Certificate number
LINE_NUM	NUMBER	(15)		Line number
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
REGIME_CODE	VARCHAR2	(30)		Indicates type of regime. Possible values are 'TCS' , 'TDS'

Query Text

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


SELECT ORGANIZATION_ID
,      LEGAL_ENTITY
,      FIN_YR
,      ORG_TAN_NUM
,      FIN_YR_CERT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CERTIFICATE_NUM
,      LINE_NUM
,      OBJECT_VERSION_NUMBER
,      REGIME_CODE
FROM JA.JAI_AP_TDS_CERT_NUMS;

Dependencies

[top of page]

JA.JAI_AP_TDS_CERT_NUMS does not reference any database object

JA.JAI_AP_TDS_CERT_NUMS is referenced by following:

JA: JAI_AP_TDS_CERT_NUMS#