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

TABLE: JA.JAI_AP_TDS_SEC_MAP

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_AP_TDS_SEC_MAP_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSECTION_MAPPING_ID
Columns
Name Datatype Length Mandatory Comments
SECTION_MAPPING_ID NUMBER

Sequence no JA. JAI_AP_SECTION_MAPPING_S
REGIME_ID NUMBER

Regime ID
SECTION_CODE VARCHAR2 (30)
Section code
SECTION_CODE_REVISED VARCHAR2 (30)
Revised section code to be used in eTDS
FROM_DATE DATE

Effective from date
TO_DATE DATE

Effective to date
FORM_TYPE VARCHAR2 (1)
1: 27Q, 2: 26Q
CREATION_DATE DATE

Set who column
CREATED_BY NUMBER

Set who column
LAST_UPDATE_DATE DATE

Set who column
LAST_UPDATE_LOGIN NUMBER

Set who column
LAST_UPDATED_BY NUMBER

Set who column
Query Text

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


SELECT SECTION_MAPPING_ID
,      REGIME_ID
,      SECTION_CODE
,      SECTION_CODE_REVISED
,      FROM_DATE
,      TO_DATE
,      FORM_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
FROM JA.JAI_AP_TDS_SEC_MAP;

Dependencies

[top of page]

JA.JAI_AP_TDS_SEC_MAP does not reference any database object

JA.JAI_AP_TDS_SEC_MAP is referenced by following:

SchemaJA
ViewJAI_AP_TDS_SEC_MAP#