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

TABLE: JA.JAI_RCV_TP_INV_DETAILS

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


Whenever a third party invoice is created for Receipt Third Party Taxes by India Localization, this table gets populated with invoice lines


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_RCV_TP_INV_DETAILS_PK NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_LINE_ID
Columns
Name Datatype Length Mandatory Comments
BATCH_LINE_ID NUMBER
Yes Line batch identifier
BATCH_INVOICE_ID NUMBER
Yes Invoice batch identifier
RCV_TRANSACTION_ID NUMBER

Receipt identifier, RCV_TRANSACTIONS.TRANSACTION_ID, of receipt that this hold is associated with
LINE_NUMBER NUMBER
Yes Line number
TAX_ID NUMBER
Yes Tax identifier for the tax code to be used.
TAX_AMOUNT NUMBER
Yes Tax amount
TAXABLE_BASIS NUMBER

Taxable basis
TAX_TYPE VARCHAR2 (30)
Type of tax
TAX_RATE NUMBER

Tax rate
CREATED_BY NUMBER

Standard who column
CREATION_DATE DATE

Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER

Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
OBJECT_VERSION_NUMBER NUMBER

Object version number
Query Text

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


SELECT BATCH_LINE_ID
,      BATCH_INVOICE_ID
,      RCV_TRANSACTION_ID
,      LINE_NUMBER
,      TAX_ID
,      TAX_AMOUNT
,      TAXABLE_BASIS
,      TAX_TYPE
,      TAX_RATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_RCV_TP_INV_DETAILS;

Dependencies

[top of page]

JA.JAI_RCV_TP_INV_DETAILS does not reference any database object

JA.JAI_RCV_TP_INV_DETAILS is referenced by following:

SchemaJA
ViewJAI_RCV_TP_INV_DETAILS#