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: JL.JL_CL_AP_AWT_CERT

Object Details

Object Name:	JL_CL_AP_AWT_CERT
Object Type:	TABLE
Owner:	JL
FND Design Data:	JL.JL_CL_AP_AWT_CERT
Subobject Name:
Status:	VALID

JL_CL_AP_AWT_CERT stores the information about certificates which were previously printed. The user may re-print using the certificate information stored in this table. This certificate represents the year relevant to the certificate, certificate number, CPI factor used, the total service amount and participation service amount for each supplier, for each set of books, for each organization. If it is under non-multiple organization environment, ORG_ID column has the company identification which issues the certificate.
.
The certificate has three different statuses, which are PRELIMINARY, FINAL, and REPRINTED. If a user prints out the certificate to preview, the certificate has 'P' status. Whenever a user previews certificates, the certificate data which is previously previewed is removed and a new certificate for preview is created here using 'P' status again. If a user issues the finalized certificate, the previewed certificate is removed and then the finalized certificate is created here using 'F' status. Once finalized, a user cannot preview the certificate again. Instead, the user can review it or reprint the certificate for a specific supplier. If the user reprints the certificate for a specific supplier, the status becomes 'R'. All the certificates with status 'R' are certificates already finalized. There are two different kinds of certificates.
The column PARTICIPATION_FLAG is used to identify certificates that are 'Professional Service Fee' or 'Professional Service and Participation Fee'. If it is 'Y', the certificate is 'Professional Service and Participation Fee'.
The columns SERVICE_AMOUNT, PARTICIPATION_AMOUNT, TAX_AMOUNT are used to store the total amount for each supplier, certificate year, set of books and organization for the purpose of review. If a user issues a reviewing certificate, those columns can be reused to report the total amount.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JL_CL_AP_AWT_CERT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CERTIFICATE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CERTIFICATE_ID	NUMBER	(15)	Yes	Sequence ID
CERTIFICATE_NUMBER	NUMBER	(10)	Yes	Certificate number generated by system
CERTIFICATE_YEAR	NUMBER	(4)	Yes	The year applied to the certificate
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books ID
ORG_ID	NUMBER	(15)	Yes	Organization ID (JG Company ID profile option value is stored in multi-org environment)
VENDOR_ID	NUMBER	(15)	Yes	Supplier ID
PRICE_INDEX_ID	NUMBER	(15)	Yes	Price Index ID
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
STATUS	VARCHAR2	(1)	Yes	Indicates certificate status. P=Preliminary, F=Final, R=Reprinted.
PARTICIPATION_FLAG	VARCHAR2	(1)	Yes	Indicate certificate contains participation fee
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
TAXPAYER_ID_NUMBER	VARCHAR2	(30)		Taxpayer identification
REPRINT_DATE	DATE			Last certificate reprint date
SERVICE_AMOUNT	NUMBER			Sum of service fee invoice amount
PARTICIPATION_AMOUNT	NUMBER			Sum of Service and Participation Fee invoice amount
TAX_AMOUNT	NUMBER			Sum of withholding tax amount
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
LEGAL_ENTITY_ID	NUMBER	(15)		Legal entity ID

Query Text

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


SELECT CERTIFICATE_ID
,      CERTIFICATE_NUMBER
,      CERTIFICATE_YEAR
,      SET_OF_BOOKS_ID
,      ORG_ID
,      VENDOR_ID
,      PRICE_INDEX_ID
,      CREATED_BY
,      LAST_UPDATED_BY
,      STATUS
,      PARTICIPATION_FLAG
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      TAXPAYER_ID_NUMBER
,      REPRINT_DATE
,      SERVICE_AMOUNT
,      PARTICIPATION_AMOUNT
,      TAX_AMOUNT
,      LAST_UPDATE_LOGIN
,      LEGAL_ENTITY_ID
FROM JL.JL_CL_AP_AWT_CERT;

Dependencies

[top of page]

JL.JL_CL_AP_AWT_CERT does not reference any database object

JL.JL_CL_AP_AWT_CERT is referenced by following:

APPS: JL_CL_AP_AWT_CERT