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

VIEW: APPS.GMP_PDR_BUYER_V

Object Details
Object Name: GMP_PDR_BUYER_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMP.GMP_PDR_BUYER_V
Subobject Name:
Status: VALID

View Type

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


Unique list of buyers from msc_system_items in each organization for an instance and plan


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUYER_NAME VARCHAR2 (240)
Buyer Name.
BUYER_ID NUMBER (9)
Buyer ID.
ORGANIZATION_ID NUMBER
Yes Organization ID.
SR_INSTANCE_ID NUMBER
Yes Instance ID.
PLAN_ID NUMBER
Yes Plan ID.
Query Text

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


SELECT BUYER_NAME
,      BUYER_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      PLAN_ID
FROM APPS.GMP_PDR_BUYER_V;

Dependencies

[top of page]

APPS.GMP_PDR_BUYER_V references the following:

SchemaAPPS
SynonymMSC_SYSTEM_ITEMS

APPS.GMP_PDR_BUYER_V is not referenced by any database object