[Home] [Help] [Dependency Information]
Object Name: | PO_ALERT_CONTRACT_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.PO_ALERT_CONTRACT_VIEW |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PO_NUM | VARCHAR2 | (20) | Yes | Purchase order document number |
END_DATE | DATE | Expiration date of the document | ||
AMOUNT_LIMIT | NUMBER | Maximum amount that can be released against a document | ||
CURRENCY_CODE | VARCHAR2 | (15) | Unique identifier for the currency | |
EMAIL_ADDRESS | VARCHAR2 | (240) | Electronic mail address of the employee | |
START_DATE_ACTIVE | DATE | Effective date of the notification | ||
END_DATE_ACTIVE | DATE | Expiration date of the notification | ||
NOTIFICATION_CONDITION_CODE | VARCHAR2 | (25) | Notification type | |
NOTIFICATION_AMOUNT | NUMBER | Notification amount of document total | ||
NOTIFICATION_QTY_PERCENTAGE | NUMBER | Notification percentage of document total | ||
AGREED_AMOUNT | NUMBER | Amount agreed of the purchase order | ||
TOTAL_AMOUNT | NUMBER | Calculated total amount of the document | ||
NOTIFICATION_ID | NUMBER | Yes | ||
ORG_ID | NUMBER | Organization identifier |
Cut, paste (and edit) the following text to query this object:
SELECT PO_NUM
, END_DATE
, AMOUNT_LIMIT
, CURRENCY_CODE
, EMAIL_ADDRESS
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, NOTIFICATION_CONDITION_CODE
, NOTIFICATION_AMOUNT
, NOTIFICATION_QTY_PERCENTAGE
, AGREED_AMOUNT
, TOTAL_AMOUNT
, NOTIFICATION_ID
, ORG_ID
FROM APPS.PO_ALERT_CONTRACT_VIEW;
APPS.PO_ALERT_CONTRACT_VIEW is not referenced by any database object
|
|
|