[Home] [Help] [Dependency Information]
Object Name: | IGW_ORGANIZATION_TYPES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGW.IGW_ORGANIZATION_TYPES_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
APPS.IGW_ORGANIZATION_TYPES_V is not referenced by any database object
|
|
|