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

VIEW: APPS.IGW_ORGANIZATION_TYPES_V

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

View Type

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


IGW_ORGANIZATION_TYPES_V displays the applicant organization's type. This view has eight columns for eight types of organizations. The eight types of organizations are General, Small Business, Minority-owned business, Women-owned business, Federal, State, Local, and Nonprofit. A value of X for a field means True and NULL means False.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Yes Proposal identifier
PROPOSAL_NUMBER VARCHAR2 (30) Yes Proposal number
ORGANIZATION_ID NUMBER (15)
Organization identifier
GENERAL VARCHAR2 (4000)
General business
SMALL_BUSINESS VARCHAR2 (4000)
Small business
MINORITY_BUSINESS VARCHAR2 (4000)
Minority-owned business
WOMEN_BUSINESS VARCHAR2 (4000)
Women-owned business
DISADVANTAGED VARCHAR2 (4000)
Small Disadvantaged
FEDERAL VARCHAR2 (4000)
Federal organization
STATE VARCHAR2 (4000)
State organization
LOCAL VARCHAR2 (4000)
Local organization
NON_PROFIT VARCHAR2 (4000)
Nonprofit organization
Query Text

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


SELECT PROPOSAL_ID
,      PROPOSAL_NUMBER
,      ORGANIZATION_ID
,      GENERAL
,      SMALL_BUSINESS
,      MINORITY_BUSINESS
,      WOMEN_BUSINESS
,      DISADVANTAGED
,      FEDERAL
,      STATE
,      LOCAL
,      NON_PROFIT
FROM APPS.IGW_ORGANIZATION_TYPES_V;

Dependencies

[top of page]

APPS.IGW_ORGANIZATION_TYPES_V references the following:

SchemaAPPS
SynonymIGW_PROPOSALS_ALL
PL/SQL PackageIGW_REPORT_PROCESSING - show dependent code

APPS.IGW_ORGANIZATION_TYPES_V is not referenced by any database object