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


VIEW: APPS.IGW_PROP_V

Object Details
Object Name: IGW_PROP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGW.IGW_PROP_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Yes
PROPOSAL_NUMBER VARCHAR2 (30) Yes
PROPOSAL_TYPE_CODE VARCHAR2 (30) Yes
PI_ID NUMBER (15)
PI_NAME VARCHAR2 (240)
SPONSOR_ID NUMBER (15)
SPONSOR_NAME VARCHAR2 (50)
PROJECT_LOCATION_ID NUMBER

PROJECT_LOCATION_NAME VARCHAR2 (4000)
MAJOR_GOALS VARCHAR2 (4000)
PROPOSAL_START_DATE DATE
Yes
PROPOSAL_END_DATE DATE
Yes
ANNUAL_DIRECT_COST NUMBER

TOTAL_COST NUMBER

PROPOSAL_TITLE VARCHAR2 (250)
SPONSOR_ACTION_CODE VARCHAR2 (30)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
Query Text

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


SELECT PROPOSAL_ID
,      PROPOSAL_NUMBER
,      PROPOSAL_TYPE_CODE
,      PI_ID
,      PI_NAME
,      SPONSOR_ID
,      SPONSOR_NAME
,      PROJECT_LOCATION_ID
,      PROJECT_LOCATION_NAME
,      MAJOR_GOALS
,      PROPOSAL_START_DATE
,      PROPOSAL_END_DATE
,      ANNUAL_DIRECT_COST
,      TOTAL_COST
,      PROPOSAL_TITLE
,      SPONSOR_ACTION_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.IGW_PROP_V;

Dependencies

[top of page]

APPS.IGW_PROP_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
ViewIGW_PROPOSALS
PL/SQL PackageIGW_PROP_COSTS - show dependent code
SynonymIGW_PROP_PERSONS
PL/SQL PackageIGW_VIEW_PARAMETERS - show dependent code
ViewPER_PEOPLE_X
APPS.IGW_PROP_V is referenced by following:

SchemaAPPS
Package BodyIGW_PROP_PERSON_SUPPORT_PVT - show dependent code