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_GA_ORG_ASSIGNMENTS_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view retrieves existing Global Agreement org assignment information.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		ROWID from table PO_GA_ORG_ASSIGNMENTS
PO_HEADER_ID	NUMBER		Yes	Global Agreement unique identifier
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Display name of the requesting operating unit.
ORG_ID	NUMBER		Yes	Organization identifier
ENABLED_FLAG	VARCHAR2	(1)	Yes	Enabled status for the organization w/ respect to this Global Agreement.
VENDOR_ID	NUMBER		Yes	Supplier unique identifier.
VENDOR_SITE_ID	NUMBER		Yes	Vendor Site ID for the purchasing operating unit.
VENDOR_SITE_CODE	VARCHAR2	(15)	Yes	Display name for Supplier Site.
OWNING_STATUS	NUMBER			Used for ordering orgs (Owning Org is listed first).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PURCHASING_ORG_NAME	VARCHAR2	(240)	Yes	Purchasing operating unit name.
PURCHASING_ORG_ID	NUMBER		Yes	Purchasing operating unit unique identifier. When enabled, this operating unit can purchase against the Global Agreement.

Query Text

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


SELECT ROW_ID
,      PO_HEADER_ID
,      ORGANIZATION_NAME
,      ORG_ID
,      ENABLED_FLAG
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      OWNING_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PURCHASING_ORG_NAME
,      PURCHASING_ORG_ID
FROM APPS.PO_GA_ORG_ASSIGNMENTS_V;

Dependencies

[top of page]

APPS.PO_GA_ORG_ASSIGNMENTS_V references the following:

APPS: HR_OPERATING_UNITS; PO_GA_ORG_ASSIGNMENTS; PO_HEADERS_ALL; PO_VENDOR_SITES_ALL

APPS.PO_GA_ORG_ASSIGNMENTS_V is not referenced by any database object