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

TABLE: INL.INL_MATCHES

Object Details
Object Name: INL_MATCHES
Object Type: TABLE
Owner: INL
FND Design Data: TableINL.INL_MATCHES
Subobject Name:
Status: VALID


This table stores actual amounts and the shipment components they refer to, to be used in actual landed cost calculation.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
INL_MATCHES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMATCH_ID
INL_MATCHES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFROM_PARENT_TABLE_NAME
ColumnFROM_PARENT_TABLE_ID
INL_MATCHES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMATCH_AMOUNT_ID
INL_MATCHES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTO_PARENT_TABLE_NAME
ColumnTO_PARENT_TABLE_ID
INL_MATCHES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFROM_PARENT_TABLE_NAME
ColumnFROM_PARENT_TABLE_ID
ColumnTO_PARENT_TABLE_NAME
ColumnTO_PARENT_TABLE_ID
INL_MATCHES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIP_HEADER_ID
ColumnADJUSTMENT_NUM
INL_MATCHES_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_MATCH_ID
ColumnMATCH_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
MATCH_ID NUMBER
Yes Match Identifier
MATCH_TYPE_CODE VARCHAR2 (30) Yes Match Type Code
SHIP_HEADER_ID NUMBER

Shipment Identifier
FROM_PARENT_TABLE_NAME VARCHAR2 (30)
Identifier of the table line the match comes from.
FROM_PARENT_TABLE_ID NUMBER

Identifier of the table line the match comes from.
TO_PARENT_TABLE_NAME VARCHAR2 (30)
Name of the table the match goes to: INL_SHIP_LINES
TO_PARENT_TABLE_ID NUMBER

Identifier of the table line the match goes to: SHIP_LINE_ID
PARENT_MATCH_ID NUMBER

Parent Match Identifier
MATCHED_QTY NUMBER

Matched Quantity
MATCHED_UOM_CODE VARCHAR2 (3)
Matched Unit of Measure Code
MATCHED_AMT NUMBER

Matched Amount
MATCHED_CURR_CODE VARCHAR2 (15)
Matched Currency Code
MATCHED_CURR_CONVERSION_TYPE VARCHAR2 (30)
Match Currency Conversion Type
MATCHED_CURR_CONVERSION_DATE DATE

Match Currency Conversion Date
MATCHED_CURR_CONVERSION_RATE NUMBER

Match Currency Conversion Rate
ADJ_ALREADY_GENERATED_FLAG VARCHAR2 (1) Yes "Y" or "N" flag indicating whether the match has already generated adjustments
REPLACE_ESTIM_QTY_FLAG VARCHAR2 (1) Yes "Y" or "N" flag indicating whether the quantities should be also adjusted beside the amounts.
EXISTING_MATCH_INFO_FLAG VARCHAR2 (1) Yes "Y" or "N" flag indicating whether the match corresponds to data already matched (match update)
CHARGE_LINE_TYPE_ID NUMBER

Charge Line Type Identifier
PARTY_ID NUMBER

Party Identifier
PARTY_SITE_ID NUMBER

Party Site Identifier
TAX_CODE VARCHAR2 (30)
Tax Code
NREC_TAX_AMT NUMBER

Non Recoverable Tax Amount
TAX_AMT_INCLUDED_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating whether the tax is included to the unit price.
MATCH_AMOUNT_ID NUMBER

Match Amount Identifier
MATCH_INT_ID NUMBER

Match Interface Identifier
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ADJ_GROUP_DATE DATE

Group date for adjustment creation
ADJUSTMENT_NUM NUMBER

Number of the Adjustment generated by this match
Query Text

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


SELECT MATCH_ID
,      MATCH_TYPE_CODE
,      SHIP_HEADER_ID
,      FROM_PARENT_TABLE_NAME
,      FROM_PARENT_TABLE_ID
,      TO_PARENT_TABLE_NAME
,      TO_PARENT_TABLE_ID
,      PARENT_MATCH_ID
,      MATCHED_QTY
,      MATCHED_UOM_CODE
,      MATCHED_AMT
,      MATCHED_CURR_CODE
,      MATCHED_CURR_CONVERSION_TYPE
,      MATCHED_CURR_CONVERSION_DATE
,      MATCHED_CURR_CONVERSION_RATE
,      ADJ_ALREADY_GENERATED_FLAG
,      REPLACE_ESTIM_QTY_FLAG
,      EXISTING_MATCH_INFO_FLAG
,      CHARGE_LINE_TYPE_ID
,      PARTY_ID
,      PARTY_SITE_ID
,      TAX_CODE
,      NREC_TAX_AMT
,      TAX_AMT_INCLUDED_FLAG
,      MATCH_AMOUNT_ID
,      MATCH_INT_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ADJ_GROUP_DATE
,      ADJUSTMENT_NUM
FROM INL.INL_MATCHES;

Dependencies

[top of page]

INL.INL_MATCHES does not reference any database object

INL.INL_MATCHES is referenced by following:

SchemaINL
ViewINL_MATCHES#