DBA Data[Home] [Help] [Dependency Information]

TABLE: JA.JAI_AP_TDS_THHOLD_XCEPS

Object Details
Object Name: JAI_AP_TDS_THHOLD_XCEPS
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_AP_TDS_THHOLD_XCEPS
Subobject Name:
Status: VALID


This table stores teh details of all exception TDS thresholds. It keeps the set of vendor, Vendor PAN and org TAN for which the exception is applicable.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_AP_TDS_THHOLD_XCEPS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTHRESHOLD_EXCEPTION_ID
JAI_AP_TDS_THHOLD_XCEPS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTHRESHOLD_HDR_ID
ColumnVENDOR_ID
ColumnORG_TAN
ColumnVENDOR_PAN
Columns
Name Datatype Length Mandatory Comments
THRESHOLD_EXCEPTION_ID NUMBER (15) Yes Threshold exception identifier
THRESHOLD_HDR_ID NUMBER (15) Yes Threshold header identifier
VENDOR_ID NUMBER

Supplier identifier
ORG_TAN VARCHAR2 (30)
Organization TAN number.
VENDOR_PAN VARCHAR2 (30)
PAN number of the supplier
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.
PROSPECTIVE_FLAG VARCHAR2 (1)
Prospective flag
Query Text

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


SELECT THRESHOLD_EXCEPTION_ID
,      THRESHOLD_HDR_ID
,      VENDOR_ID
,      ORG_TAN
,      VENDOR_PAN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      PROSPECTIVE_FLAG
FROM JA.JAI_AP_TDS_THHOLD_XCEPS;

Dependencies

[top of page]

JA.JAI_AP_TDS_THHOLD_XCEPS does not reference any database object

JA.JAI_AP_TDS_THHOLD_XCEPS is referenced by following:

SchemaJA
ViewJAI_AP_TDS_THHOLD_XCEPS#