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_RGM_CERTIFICATES

Object Details

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

This table stores the certificate information of Customers.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_RGM_CERTIFICATES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CERTIFICATE_ID
JAI_RGM_CERTIFICATES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORG_TAN_NO FIN_YEAR CERTIFICATE_NUM
JAI_RGM_CERTIFICATES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_TYPE PARTY_ID PARTY_SITE_ID
JAI_RGM_CERTIFICATES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TAX_AUTHORITY_ID TAX_AUTHORITY_SITE_ID
JAI_RGM_CERTIFICATES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
JAI_RGM_CERTIFICATES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_TAN_NO

Columns

Name	Datatype	Length	Mandatory	Comments
CERTIFICATE_ID	NUMBER		Yes	Indicates Certificate Identifier
CERTIFICATE_NUM	NUMBER		Yes	Indicates Certificate Number
CERTIFICATE_DATE	DATE		Yes	Indicates Certificate Creation Date
PARTY_TYPE	VARCHAR2	(15)	Yes	Indicates Party Type
PARTY_ID	NUMBER	(15)	Yes	Indicates Customer Identifier.
PARTY_SITE_ID	NUMBER	(15)	Yes	Indicates Customer Site identifier
REGIME_ID	NUMBER		Yes	Indicates Regime Identifier
TAX_AUTHORITY_ID	NUMBER	(15)	Yes	Indicates the Tax Authority Identifier.
TAX_AUTHORITY_SITE_ID	NUMBER	(15)	Yes	Indicates Tax Authority Site Identifier
FROM_DATE	DATE		Yes	Indicates start Date of the Certificate
TO_DATE	DATE		Yes	Indicates end Date of the Certificate
PRINT_FLAG	VARCHAR2	(1)		Indicates whether the Certificate has been Issued
ORGANIZATION_ID	NUMBER	(15)	Yes	Indicates inventory organization identifier.
ISSUE_DATE	DATE			Indicates Certificate Issue Date
FIN_YEAR	NUMBER	(4)	Yes	Indicates Financial Year
ORG_TAN_NO	VARCHAR2	(240)	Yes	Indicates Tax Account Number of the organization
PROGRAM_ID	NUMBER	(15)	Yes	Indicates the Concurrent program identifier that generated the certificates
PROGRAM_LOGIN_ID	NUMBER	(15)	Yes	Concurrent Program Login Id
PROGRAM_APPLICATION_ID	NUMBER	(15)	Yes	Concurrent Program Application Id
REQUEST_ID	NUMBER	(15)	Yes	Concurrent Program Request Id
OBJECT_VERSION_NUMBER	NUMBER	(9)		Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

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


SELECT CERTIFICATE_ID
,      CERTIFICATE_NUM
,      CERTIFICATE_DATE
,      PARTY_TYPE
,      PARTY_ID
,      PARTY_SITE_ID
,      REGIME_ID
,      TAX_AUTHORITY_ID
,      TAX_AUTHORITY_SITE_ID
,      FROM_DATE
,      TO_DATE
,      PRINT_FLAG
,      ORGANIZATION_ID
,      ISSUE_DATE
,      FIN_YEAR
,      ORG_TAN_NO
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM JA.JAI_RGM_CERTIFICATES;

Dependencies

[top of page]

JA.JAI_RGM_CERTIFICATES does not reference any database object

JA.JAI_RGM_CERTIFICATES is referenced by following:

JA: JAI_RGM_CERTIFICATES#