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_SGD_HEADERS_V

Object Details

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

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns

Name	Datatype	Length	Comments
PK1_VALUE	NUMBER		Primary Key Value
PK2_VALUE	NUMBER		Primary Key Value
PK3_VALUE	VARCHAR2	(0)	Primary Key Value
PK4_VALUE	VARCHAR2	(0)	Primary Key Value
PK5_VALUE	VARCHAR2	(0)	Primary Key Value
COL_NAME	VARCHAR2	(30)	Column Name
COL_VALUE	VARCHAR2	(2000)	Column Value
COL_DESC	VARCHAR2	(2000)	Column description

Query Text

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


SELECT PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      COL_NAME
,      COL_VALUE
,      COL_DESC
FROM APPS.PO_SGD_HEADERS_V;

Dependencies

[top of page]

APPS.PO_SGD_HEADERS_V references the following:

APPS: AP_TERMS; FND_GLOBAL - show dependent code; FND_LOOKUPS; HR_LOCATIONS_ALL; ORG_FREIGHT_TL; PER_ALL_PEOPLE_F; PO_DATATEMPLATE_PKG - show dependent code; PO_GEN_DIFF_PKG - show dependent code; PO_HEADERS_ALL; PO_LOOKUP_CODES; PO_SUPPLIER_CONTACTS_VAL_V; PO_VENDOR_SITES_ALL

APPS.PO_SGD_HEADERS_V is not referenced by any database object