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

VIEW: APPS.MSD_DP_ISO_ORGANIZATIONS_V

Object Details
Object Name: MSD_DP_ISO_ORGANIZATIONS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


This view shows the ISO Organizations in a plan.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID of the record
DEMAND_PLAN_ID NUMBER
Yes Demand Plan Identifier
SR_INSTANCE_ID VARCHAR2 (240) Yes Source Instance Identifier
SR_ORGANIZATION_ID VARCHAR2 (240) Yes Organization Identifier
ORGANIZATION_NAME VARCHAR2 (240) Yes Name of the Organization Selected for Internal Transfers
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
REQUEST_ID NUMBER

Enhanced Who Column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who Column
PROGRAM_ID NUMBER

Enhanced Who Column
PROGRAM_UPDATE_DATE DATE

Enhanced Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
Query Text

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


SELECT ROW_ID
,      DEMAND_PLAN_ID
,      SR_INSTANCE_ID
,      SR_ORGANIZATION_ID
,      ORGANIZATION_NAME
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
FROM APPS.MSD_DP_ISO_ORGANIZATIONS_V;

Dependencies

[top of page]

APPS.MSD_DP_ISO_ORGANIZATIONS_V references the following:

SchemaAPPS
SynonymMSD_DP_ISO_ORGANIZATIONS
SynonymMSD_LEVEL_VALUES

APPS.MSD_DP_ISO_ORGANIZATIONS_V is not referenced by any database object