eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JA.JAI_AP_INVOICE_LINES

Object Details

Object Name:	JAI_AP_INVOICE_LINES
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_AP_INVOICE_LINES
Subobject Name:
Status:	VALID

This table is used to store the taxes related with standalone payables invoices

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AP_INVOICE_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	JAI_AP_INVOICE_LINES_ID
JAI_AP_INVOICE_LINES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVOICE_ID INVOICE_LINE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
JAI_AP_INVOICE_LINES_ID	NUMBER		Yes	Primary Key populated by sequence
ORGANIZATION_ID	NUMBER	(15)		Organization Identifier
LOCATION_ID	NUMBER	(15)		Location Identifier
INVOICE_ID	NUMBER	(15)	Yes	Invoice Identifier
INVOICE_LINE_NUMBER	NUMBER	(15)	Yes	Invoice line number
SUPPLIER_SITE_ID	NUMBER	(15)		Supplier Site Identifier
PARENT_INVOICE_LINE_NUMBER	NUMBER	(15)		Line number of the parent invoice to which IL Tax lines are associated
TAX_CATEGORY_ID	NUMBER	(15)		Tax Category Identifier
SERVICE_TYPE_CODE	VARCHAR2	(30)		Service Type
MATCH_TYPE	VARCHAR2	(30)		Indicates the type of match if any.
CURRENCY_CODE	VARCHAR2	(15)		Currency code of Invoice
LINE_AMOUNT	NUMBER			Line amount in invoice currency
LINE_TYPE_LOOKUP_CODE	VARCHAR2	(25)		Type of invoice line. Valid values from INVOICE LINE TYPE lookup codes.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
INTERFACE_FLAG	VARCHAR2	(1)		Identifier of data from Open interface, Y or NULL
INTERFACE_EVENT	VARCHAR2	(20)		STANDARD or EXTERNAL

Query Text

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


SELECT JAI_AP_INVOICE_LINES_ID
,      ORGANIZATION_ID
,      LOCATION_ID
,      INVOICE_ID
,      INVOICE_LINE_NUMBER
,      SUPPLIER_SITE_ID
,      PARENT_INVOICE_LINE_NUMBER
,      TAX_CATEGORY_ID
,      SERVICE_TYPE_CODE
,      MATCH_TYPE
,      CURRENCY_CODE
,      LINE_AMOUNT
,      LINE_TYPE_LOOKUP_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      INTERFACE_FLAG
,      INTERFACE_EVENT
FROM JA.JAI_AP_INVOICE_LINES;

Dependencies

[top of page]

JA.JAI_AP_INVOICE_LINES does not reference any database object

JA.JAI_AP_INVOICE_LINES is referenced by following:

JA: JAI_AP_INVOICE_LINES#