[Home] [Help] [Dependency Information]
Object Name: | PO_HEADER_RELEASE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.PO_HEADER_RELEASE_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEGMENT1 | VARCHAR2 | (20) | Yes | Key flexfield segment |
TYPE_NAME | VARCHAR2 | (80) | Yes | |
STATUS | VARCHAR2 | (240) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
PO_HEADER_ID | NUMBER | Yes | ||
TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Yes | |
REVISION_NUM | NUMBER | |||
AGENT_ID | NUMBER | (9) | Yes | |
SECURITY_LEVEL_CODE | VARCHAR2 | (25) | ||
VENDOR_NAME | VARCHAR2 | (240) | ||
VENDOR_SITE_ID | NUMBER | |||
AGENT_NAME | VARCHAR2 | (240) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
AUTHORIZATION_STATUS | VARCHAR2 | (25) | ||
FOB_LOOKUP_CODE | VARCHAR2 | (25) | ||
FREIGHT_TERMS_LOOKUP_CODE | VARCHAR2 | (25) | ||
VENDOR_CONTACT_ID | NUMBER | |||
TERMS_ID | NUMBER | |||
BLANKET_TOTAL_AMOUNT | NUMBER | |||
COMMENTS | VARCHAR2 | (240) | ||
NOTE_TO_VENDOR | VARCHAR2 | (480) | ||
NOTE_TO_RECEIVER | VARCHAR2 | (480) | ||
SHIP_VIA_LOOKUP_CODE | VARCHAR2 | (25) | ||
CONTERMS_EXIST_FLAG | VARCHAR2 | (1) | Indicates if contract terms template is attached to the purchasing document or not. Applicable to Purchasing document of type Standard, Contract, Blanket | |
PENDING_SIGNATURE_FLAG | VARCHAR2 | (1) | Indicates if the purchasing document is waiting for the signatures or not. Applicable to Purchasing document of type Standard, Contract, Blanket | |
AMOUNT_LIMIT | NUMBER | Maximum amount that can be released | ||
MIN_RELEASE_AMOUNT | NUMBER | Minimum amount that can be released | ||
PRICE_UPDATE_TOLERANCE | NUMBER | Maximum percentage allowed in price/sales catalog update sent by supplier | ||
ORG_ID | NUMBER | Organization identifier |
Cut, paste (and edit) the following text to query this object:
SELECT SEGMENT1
, TYPE_NAME
, STATUS
, DESCRIPTION
, PO_HEADER_ID
, TYPE_LOOKUP_CODE
, REVISION_NUM
, AGENT_ID
, SECURITY_LEVEL_CODE
, VENDOR_NAME
, VENDOR_SITE_ID
, AGENT_NAME
, START_DATE
, END_DATE
, AUTHORIZATION_STATUS
, FOB_LOOKUP_CODE
, FREIGHT_TERMS_LOOKUP_CODE
, VENDOR_CONTACT_ID
, TERMS_ID
, BLANKET_TOTAL_AMOUNT
, COMMENTS
, NOTE_TO_VENDOR
, NOTE_TO_RECEIVER
, SHIP_VIA_LOOKUP_CODE
, CONTERMS_EXIST_FLAG
, PENDING_SIGNATURE_FLAG
, AMOUNT_LIMIT
, MIN_RELEASE_AMOUNT
, PRICE_UPDATE_TOLERANCE
, ORG_ID
FROM APPS.PO_HEADER_RELEASE_V;
APPS.PO_HEADER_RELEASE_V is not referenced by any database object
|
|
|