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

TABLE: PO.PO_WARRANT_LINES

Object Details
Object Name: PO_WARRANT_LINES
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_WARRANT_LINES
Subobject Name:
Status: VALID


Warrant lines information contains amount per document type, award type, and warrant type.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_WARRANT_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWARRANT_ID
ColumnTYPE_LOOKUP_CODE
ColumnCLM_AWARD_TYPE
ColumnWARRANT_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
WARRANT_ID NUMBER
Yes Warrant identifier
TYPE_LOOKUP_CODE VARCHAR2 (25)
The document type. Valid values are lookup codes of lookup type 'PO TYPE' excluding 'PLANNED','QUOTATION','RFQ'
CLM_AWARD_TYPE VARCHAR2 (100)
The award type. Valid values include the award type lookup type spcific to the document type selected and 'ALL' value.
WARRANT_TYPE_CODE VARCHAR2 (30)
The warrant type code. Valid values are lookup codes of the user extensible lookup type 'PO_WARRANT_TYPE'.
WARRANT_AMOUNT NUMBER

The amount which is the signing limit of this combination.
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

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

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


SELECT WARRANT_ID
,      TYPE_LOOKUP_CODE
,      CLM_AWARD_TYPE
,      WARRANT_TYPE_CODE
,      WARRANT_AMOUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM PO.PO_WARRANT_LINES;

Dependencies

[top of page]

PO.PO_WARRANT_LINES does not reference any database object

PO.PO_WARRANT_LINES is referenced by following:

SchemaPO
ViewPO_WARRANT_LINES#