[Home] [Help] [Dependency Information]
Object Name: | PO_LINE_UCAS# |
---|---|
Object Type: | VIEW |
Owner: | PO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PO_LINE_UCA_ID | NUMBER | Yes | ||
PO_HEADER_ID | NUMBER | Yes | ||
PO_LINE_ID | NUMBER | Yes | ||
UNDEF_DRAFT_ID | NUMBER | Yes | ||
UNDEF_CLM_DOCUMENT_NUMBER | VARCHAR2 | (100) | ||
UNDEF_AMOUNT | NUMBER | |||
NOT_TO_EXCEED_AMOUNT | NUMBER | |||
LIMIT_GOV_LIABILITY_AMT | NUMBER | |||
PLANNED_DEF_DATE | DATE | |||
UNDEF_DESCRIPTION | VARCHAR2 | (4000) | ||
UNDEF_APPROVED_DATE | DATE | |||
DEF_DRAFT_ID | NUMBER | |||
DEF_DESCRIPTION | VARCHAR2 | (4000) | ||
DEF_APPROVED_DATE | DATE | |||
DEF_PAR_DRAFT_ID | NUMBER | |||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PO_LINE_UCA_ID
, PO_HEADER_ID
, PO_LINE_ID
, UNDEF_DRAFT_ID
, UNDEF_CLM_DOCUMENT_NUMBER
, UNDEF_AMOUNT
, NOT_TO_EXCEED_AMOUNT
, LIMIT_GOV_LIABILITY_AMT
, PLANNED_DEF_DATE
, UNDEF_DESCRIPTION
, UNDEF_APPROVED_DATE
, DEF_DRAFT_ID
, DEF_DESCRIPTION
, DEF_APPROVED_DATE
, DEF_PAR_DRAFT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM PO.PO_LINE_UCAS#;
|
|
|