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_THGRP_AUDITS

Object Details

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

This table tracks the changes that happens to the table JAI_AP_TDS_THHOLD_GRPS. This table is very important for Threshold calculation and hence is tracked for all changes.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AP_TDS_THGRP_AUDITS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	THRESHOLD_GRP_AUDIT_ID
JAI_AP_TDS_THGRP_AUDITS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	THRESHOLD_GRP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
THRESHOLD_GRP_AUDIT_ID	NUMBER	(15)	Yes	Unique identifier
THRESHOLD_GRP_ID	NUMBER	(15)	Yes	threshold group identifier
OLD_INVOICE_AMOUNT	NUMBER			Old TOTAL_INVOICE_AMOUNT
OLD_INVOICE_CANCEL_AMOUNT	NUMBER			Old TOTAL_INVOICE_CANCEL_AMOUNT
OLD_INVOICE_APPLY_AMOUNT	NUMBER			Old TOTAL_INVOICE_APPLY_AMOUNT
OLD_INVOICE_UNAPPLY_AMOUNT	NUMBER			Old TOTAL_INVOICE_UNAPPLY_AMOUNT
OLD_TAX_PAID	NUMBER			Old TOTAL_TAX_PAID
OLD_THHOLD_CHANGE_TAX_PAID	NUMBER			Old TOTAL_THHOLD_CHANGE_TAX_PAID
OLD_THRESHOLD_SLAB_ID	NUMBER	(15)		old CURRENT_THRESHOLD_SLAB_ID
TRX_INVOICE_AMOUNT	NUMBER			Transaction TOTAL_INVOICE_AMOUNT
TRX_INVOICE_CANCEL_AMOUNT	NUMBER			Transaction TOTAL_INVOICE_CANCEL_AMOUNT
TRX_INVOICE_APPLY_AMOUNT	NUMBER			Transaction TOTAL_INVOICE_APPLY_AMOUNT
TRX_INVOICE_UNAPPLY_AMOUNT	NUMBER			Transaction TOTAL_INVOICE_UNAPPLY_AMOUNT
TRX_TAX_PAID	NUMBER			Transaction TOTAL_TAX_PAID
TRX_THHOLD_CHANGE_TAX_PAID	NUMBER			Transaction TOTAL_THHOLD_CHANGE_TAX_PAID
TRX_THRESHOLD_SLAB_ID	NUMBER	(15)		Transaction CURRENT_THRESHOLD_SLAB_ID
NEW_INVOICE_AMOUNT	NUMBER			New TOTAL_INVOICE_AMOUNT
NEW_INVOICE_CANCEL_AMOUNT	NUMBER			New TOTAL_INVOICE_CANCEL_AMOUNT
NEW_INVOICE_APPLY_AMOUNT	NUMBER			New TOTAL_INVOICE_APPLY_AMOUNT
NEW_INVOICE_UNAPPLY_AMOUNT	NUMBER			New TOTAL_INVOICE_UNAPPLY_AMOUNT
NEW_TAX_PAID	NUMBER			New TOTAL_TAX_PAID
NEW_THHOLD_CHANGE_TAX_PAID	NUMBER			New TOTAL_THHOLD_CHANGE_TAX_PAID
NEW_THRESHOLD_SLAB_ID	NUMBER	(15)		New CURRENT_THRESHOLD_SLAB_ID
TDS_EVENT	VARCHAR2	(100)		TDS event, Possible values are INVOICE VALIDATE, INVOICE CANCEL, PREPAYMENT APPLICATION, PREPAYMENT UNAPPLICATION, MANUAL UPDATE and MIGRATION
INVOICE_ID	NUMBER	(15)		Invoice identifier
INVOICE_DISTRIBUTION_ID	NUMBER	(15)		Invoice Distribution identifier.
REMARKS	VARCHAR2	(255)		Remarks
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number.
INVOICE_LINE_NUMBER	NUMBER	(15)		Invoice Line Number
CALC_OLD_TAX_PAID	NUMBER			Old Tax Paid
CALC_TRX_TAX_PAID	NUMBER			Transaction Tax Paid
CALC_NEW_TAX_PAID	NUMBER			New Tax Paid

Query Text

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


SELECT THRESHOLD_GRP_AUDIT_ID
,      THRESHOLD_GRP_ID
,      OLD_INVOICE_AMOUNT
,      OLD_INVOICE_CANCEL_AMOUNT
,      OLD_INVOICE_APPLY_AMOUNT
,      OLD_INVOICE_UNAPPLY_AMOUNT
,      OLD_TAX_PAID
,      OLD_THHOLD_CHANGE_TAX_PAID
,      OLD_THRESHOLD_SLAB_ID
,      TRX_INVOICE_AMOUNT
,      TRX_INVOICE_CANCEL_AMOUNT
,      TRX_INVOICE_APPLY_AMOUNT
,      TRX_INVOICE_UNAPPLY_AMOUNT
,      TRX_TAX_PAID
,      TRX_THHOLD_CHANGE_TAX_PAID
,      TRX_THRESHOLD_SLAB_ID
,      NEW_INVOICE_AMOUNT
,      NEW_INVOICE_CANCEL_AMOUNT
,      NEW_INVOICE_APPLY_AMOUNT
,      NEW_INVOICE_UNAPPLY_AMOUNT
,      NEW_TAX_PAID
,      NEW_THHOLD_CHANGE_TAX_PAID
,      NEW_THRESHOLD_SLAB_ID
,      TDS_EVENT
,      INVOICE_ID
,      INVOICE_DISTRIBUTION_ID
,      REMARKS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      INVOICE_LINE_NUMBER
,      CALC_OLD_TAX_PAID
,      CALC_TRX_TAX_PAID
,      CALC_NEW_TAX_PAID
FROM JA.JAI_AP_TDS_THGRP_AUDITS;

Dependencies

[top of page]

JA.JAI_AP_TDS_THGRP_AUDITS does not reference any database object

JA.JAI_AP_TDS_THGRP_AUDITS is referenced by following:

JA: JAI_AP_TDS_THGRP_AUDITS#