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_PO_QUOT_LINES_T

Object Details

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

Holds data for Concurrent Request to default tax when linked with Quotation

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
PO_HEADER_ID	NUMBER		Foreign key to PO_HEADERS_ALL.po_header_id.
PO_LINE_ID	NUMBER		Foreign key to PO_LINES_ALL.po_line_id.
LINE_LOCATION_ID	NUMBER		Foreign key to PO_LINE_LOCATIONS_ALL.line_location_id.
FROM_HEADER_ID	NUMBER		Indicates from which PO_HEADERS_ALL.po_header_id was the po_header_id created.
FROM_LINE_ID	NUMBER		Indicates from which PO_LINES_ALL.po_line_id was the po_line_id created.
PRICE_OVERRIDE	NUMBER		Foreign key to PO_LINE_LOCATIONS_ALL.price_override, which contains the price of the item.
UOM_CODE	VARCHAR2	(3)	Indicates the UOM of the Item in the shipment line.
ASSESSABLE_VALUE	NUMBER		Indicates the assessable value of item on which the excise duty is calculated. calculated from setups when this table is being populated.
CREATION_DATE	DATE		Standard Who column
CREATED_BY	NUMBER		Standard Who column
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER		Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
ERROR_FLAG	VARCHAR2	(1)	If `Y` then it indicates an error has occured when processing this record.
PROCESSING_TIME	DATE		The time at which the error has occured.
ERROR_MESSAGE	VARCHAR2	(1996)	Indicates the error (if any occured) that has occured during the bulk processing of this record.
OBJECT_VERSION_NUMBER	NUMBER		Object version number

Query Text

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


SELECT PO_HEADER_ID
,      PO_LINE_ID
,      LINE_LOCATION_ID
,      FROM_HEADER_ID
,      FROM_LINE_ID
,      PRICE_OVERRIDE
,      UOM_CODE
,      ASSESSABLE_VALUE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ERROR_FLAG
,      PROCESSING_TIME
,      ERROR_MESSAGE
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_PO_QUOT_LINES_T;

Dependencies

[top of page]

JA.JAI_PO_QUOT_LINES_T does not reference any database object

JA.JAI_PO_QUOT_LINES_T is referenced by following:

APPS: JAI_PO_QUOT_LINES_T