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]

VIEW: JA.JAI_AP_TDS_PREPAYMENTS#

Object Details

Object Name:	JAI_AP_TDS_PREPAYMENTS#
Object Type:	VIEW
Owner:	JA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
TDS_PREPAYMENT_ID	NUMBER	(15)	Yes
INVOICE_ID	NUMBER	(15)	Yes
INVOICE_DISTRIBUTION_ID_PREPAY	NUMBER	(15)	Yes
INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Yes
APPLICATION_AMOUNT	NUMBER
APPLICATION_BASIS	VARCHAR2	(30)
UNAPPLY_FLAG	VARCHAR2	(1)
TDS_SECTION_CODE_PREPAY	VARCHAR2	(30)
TDS_SECTION_CODE_OTHER	VARCHAR2	(30)
TDS_TAX_ID_PREPAY	NUMBER	(15)
TDS_TAX_ID_OTHER	NUMBER	(15)
TDS_APPLICABLE_FLAG	VARCHAR2	(1)
TDS_APPLICATION_AMOUNT	NUMBER
TDS_THRESHOLD_TRX_ID_APPLY	NUMBER	(15)
TDS_THRESHOLD_TRX_ID_UNAPPLY	NUMBER	(15)
TDS_THRESHOLD_GRP_ID	NUMBER	(15)
WCT_TAX_ID_PREPAY	NUMBER	(15)
WCT_TAX_ID_OTHER	NUMBER	(15)
WCT_APPLICABLE_FLAG	VARCHAR2	(1)
WCT_APPLICATION_AMOUNT	NUMBER
WCT_THRESHOLD_TRX_ID_APPLY	NUMBER	(15)
WCT_THRESHOLD_TRX_ID_UNAPPLY	NUMBER	(15)
ESSI_TAX_ID_PREPAY	NUMBER	(15)
ESSI_TAX_ID_OTHER	NUMBER	(15)
ESSI_APPLICABLE_FLAG	VARCHAR2	(1)
ESSI_APPLICATION_AMOUNT	NUMBER
ESSI_THRESHOLD_TRX_ID_APPLY	NUMBER	(15)
ESSI_THRESHOLD_TRX_ID_UNAPPLY	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
OBJECT_VERSION_NUMBER	NUMBER	(9)
CALC_ESSI_APPLN_AMT	NUMBER
CALC_TDS_APPLN_AMT	NUMBER
CALC_WCT_APPLN_AMT	NUMBER

Query Text

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


SELECT TDS_PREPAYMENT_ID
,      INVOICE_ID
,      INVOICE_DISTRIBUTION_ID_PREPAY
,      INVOICE_DISTRIBUTION_ID
,      APPLICATION_AMOUNT
,      APPLICATION_BASIS
,      UNAPPLY_FLAG
,      TDS_SECTION_CODE_PREPAY
,      TDS_SECTION_CODE_OTHER
,      TDS_TAX_ID_PREPAY
,      TDS_TAX_ID_OTHER
,      TDS_APPLICABLE_FLAG
,      TDS_APPLICATION_AMOUNT
,      TDS_THRESHOLD_TRX_ID_APPLY
,      TDS_THRESHOLD_TRX_ID_UNAPPLY
,      TDS_THRESHOLD_GRP_ID
,      WCT_TAX_ID_PREPAY
,      WCT_TAX_ID_OTHER
,      WCT_APPLICABLE_FLAG
,      WCT_APPLICATION_AMOUNT
,      WCT_THRESHOLD_TRX_ID_APPLY
,      WCT_THRESHOLD_TRX_ID_UNAPPLY
,      ESSI_TAX_ID_PREPAY
,      ESSI_TAX_ID_OTHER
,      ESSI_APPLICABLE_FLAG
,      ESSI_APPLICATION_AMOUNT
,      ESSI_THRESHOLD_TRX_ID_APPLY
,      ESSI_THRESHOLD_TRX_ID_UNAPPLY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      CALC_ESSI_APPLN_AMT
,      CALC_TDS_APPLN_AMT
,      CALC_WCT_APPLN_AMT
FROM JA.JAI_AP_TDS_PREPAYMENTS#;

Dependencies

[top of page]

JA.JAI_AP_TDS_PREPAYMENTS# references the following:

JA: JAI_AP_TDS_PREPAYMENTS

JA.JAI_AP_TDS_PREPAYMENTS# is referenced by following:

APPS: JAI_AP_TDS_PREPAYMENTS