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

VIEW: APPS.GMP_PLAN_ORGANIZATION_V

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

View Type

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


List of all Organizations from plan along with additional entry for All as organization. When All is selected, Planning Detail Report will consider all the organizations defined in the plan.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Organization ID.
ORGANIZATION_CODE VARCHAR2 (80)
Organization Code.
SR_INSTANCE_ID NUMBER

Instance ID.
PLAN_ID NUMBER

Plan ID.
Query Text

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


SELECT ORGANIZATION_ID
,      ORGANIZATION_CODE
,      SR_INSTANCE_ID
,      PLAN_ID
FROM APPS.GMP_PLAN_ORGANIZATION_V;

Dependencies

[top of page]

APPS.GMP_PLAN_ORGANIZATION_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMSC_PLAN_ORGANIZATIONS
APPS.GMP_PLAN_ORGANIZATION_V is referenced by following:

SchemaAPPS
Package BodyGMP_PLNG_DTL_REPORT_PKG - show dependent code