[Home] [Help] [Dependency Information]
Object Name: | JAI_PO_REQ_LINES |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JAI_PO_REQ_LINES |
Subobject Name: | |
Status: | VALID |
Stores the localization information of requisition lines and tax amounts
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JAI_PO_REQ_LINES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | REQUISITION_LINE_ID |
JAI_PO_REQ_LINES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REQUISITION_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUISITION_LINE_ID | NUMBER | (15) | Yes | Foreign key to PO_REQUISITION_LINES_ALL.requisition_line_id. |
REQUISITION_HEADER_ID | NUMBER | (15) | Yes | Foreign key to PO_REQUISITION_HEADERS_ALL.requisition_header_id. |
TAX_MODIFIED_FLAG | VARCHAR2 | (1) | Indicates the tax modified flag. | |
TAX_AMOUNT | NUMBER | Indicates the total of tax amount for requisition line from JAI_PO_REQ_LINE_TAXES. | ||
TOTAL_AMOUNT | NUMBER | Indicates the total of item cost and tax amount for line. | ||
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
TAX_CATEGORY_ID | NUMBER | (15) | Indicates from which tax category the taxes are defaulted onto the requisition line. | |
OBJECT_VERSION_NUMBER | NUMBER | Object version number |
Cut, paste (and edit) the following text to query this object:
SELECT REQUISITION_LINE_ID
, REQUISITION_HEADER_ID
, TAX_MODIFIED_FLAG
, TAX_AMOUNT
, TOTAL_AMOUNT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TAX_CATEGORY_ID
, OBJECT_VERSION_NUMBER
FROM JA.JAI_PO_REQ_LINES;
JA.JAI_PO_REQ_LINES does not reference any database object
JA.JAI_PO_REQ_LINES is referenced by following:
|
|
|