eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PO_HEADER_RELEASE_V

Object Details

Object Name:	PO_HEADER_RELEASE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.PO_HEADER_RELEASE_V
Subobject Name:
Status:	VALID

View Type

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.

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.PO_HEADER_RELEASE_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_PROFILE - show dependent code; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PER_PEOPLE_F; PO_DOCUMENT_TYPES_ALL_B; PO_DOCUMENT_TYPES_ALL_TL; PO_HEADERS; PO_LOOKUP_CODES; PO_VENDORS

APPS.PO_HEADER_RELEASE_V is not referenced by any database object