Skip to content

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

TABLE: AR.AR_GTA_TYPE_MAPPINGS

Object Details
Object Name: AR_GTA_TYPE_MAPPINGS
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_GTA_TYPE_MAPPINGS
Subobject Name:
Status: VALID


JMF_GTA_TYPE_MAPPINGS table is accessed by System Option Form. It is created to maintain the mapping between Tax Registration Number, Invoice type combination and the transaction types associated on System Options form. This table maintain one-to many relation between the tax limitations and the transaction types. (i.e., One combination of Tax registration Number and Invoice Type can be mapped to multiple transaction types, at least one).


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_GTA_TYPE_MAPPINGS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMAPPING_ID
Columns
Name Datatype Length Mandatory Comments
MAPPING_ID NUMBER
Yes Mapping identifier.
LIMITATION_ID NUMBER
Yes Limitation identifier.
TRANSACTION_TYPE_ID NUMBER
Yes Transaction type identifier.
LAST_UPDATE_DATE DATE
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (22) Yes Standard Who column
CREATED_BY NUMBER (22) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
Query Text

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


SELECT MAPPING_ID
,      LIMITATION_ID
,      TRANSACTION_TYPE_ID
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM AR.AR_GTA_TYPE_MAPPINGS;

Dependencies

[top of page]

AR.AR_GTA_TYPE_MAPPINGS does not reference any database object

AR.AR_GTA_TYPE_MAPPINGS is referenced by following:

SchemaAR
ViewAR_GTA_TYPE_MAPPINGS#