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


TABLE: JL.JL_ZZ_AR_TX_EXC_CUS_ALL

Object Details
Object Name: JL_ZZ_AR_TX_EXC_CUS_ALL
Object Type: TABLE
Owner: JL
FND Design Data: TableJL.JL_ZZ_AR_TX_EXC_CUS_ALL
Subobject Name:
Status: VALID


This table stores exceptions by customer site. It can also be used to store different tax codes or base rate modifier for different effective periods for a given customer site (ADDRESS_ID).


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JL_ZZ_AR_TX_EXC_CUS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_CATEGORY_ID
ColumnADDRESS_ID
ColumnEND_DATE_ACTIVE
ColumnORG_ID
JL_ZZ_AR_TX_EXC_CUS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXC_CUS_ID
ColumnORG_ID
JL_ZZ_AR_TX_EXC_CUS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnADDRESS_ID
ColumnEND_DATE_ACTIVE
Columns
Name Datatype Length Mandatory Comments
EXC_CUS_ID NUMBER (15) Yes Exception by customer site identifier
ADDRESS_ID NUMBER (15) Yes Address ID
TAX_CATEGORY_ID NUMBER (15) Yes Tax Category Identifier
END_DATE_ACTIVE DATE
Yes End Date Active
LAST_UPDATE_DATE DATE
Yes Last Update date
LAST_UPDATED_BY NUMBER (15) Yes Last Update date
TAX_CODE VARCHAR2 (50)
Tax Code
BASE_RATE NUMBER

Base Rate modifier
START_DATE_ACTIVE DATE

Start Date Active
ORG_ID NUMBER (15)
Multiorg identifier. Populated only if multiorg feature installed.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column
Query Text

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


SELECT EXC_CUS_ID
,      ADDRESS_ID
,      TAX_CATEGORY_ID
,      END_DATE_ACTIVE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TAX_CODE
,      BASE_RATE
,      START_DATE_ACTIVE
,      ORG_ID
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM JL.JL_ZZ_AR_TX_EXC_CUS_ALL;

Dependencies

[top of page]

JL.JL_ZZ_AR_TX_EXC_CUS_ALL does not reference any database object

JL.JL_ZZ_AR_TX_EXC_CUS_ALL is referenced by following:

SchemaAPPS
SynonymJL_ZZ_AR_TX_EXC_CUS
SynonymJL_ZZ_AR_TX_EXC_CUS_ALL