Retrieve frs organization data from fii database
1 2 3 4 5 6 7 | fii_frs_organization(ORG_UIN = NULL, ORG_NAME = NULL,
STD_ORG_NAME = NULL, ORG_TYPE = NULL, DUNS_NUMBER = NULL,
DIVISION_NAME = NULL, PHONE_NUMBER = NULL, ALTERNATE_PHONE = NULL,
FAX_NUMBER = NULL, EMAIL_ADDRESS = NULL, EIN = NULL,
STATE_BUSINESS_ID = NULL, SOURCE_OF_DATA = NULL,
LAST_REPORTED_DATE = NULL, CREATE_DATE = NULL, UPDATE_DATE = NULL,
SENSITIVE_IND = NULL, USER_ID = NULL, PUBLIC_IND = NULL)
|
ORG_UIN |
e.g. '000014958995'. See Details. |
ORG_NAME |
e.g. 'CALUMET OIL COMPANY'. See Details. |
STD_ORG_NAME |
e.g. 'CALUMET OIL COMPANY'. See Details. |
ORG_TYPE |
e.g. 'NA'. See Details. |
DUNS_NUMBER |
e.g. 'NA'. See Details. |
DIVISION_NAME |
e.g. 'NA'. See Details. |
PHONE_NUMBER |
e.g. '9187493606'. See Details. |
ALTERNATE_PHONE |
e.g. 'NA'. See Details. |
FAX_NUMBER |
e.g. 'NA'. See Details. |
EMAIL_ADDRESS |
e.g. 'NA'. See Details. |
EIN |
e.g. 'NA'. See Details. |
STATE_BUSINESS_ID |
e.g. 'NA'. See Details. |
SOURCE_OF_DATA |
e.g. 'ICIS'. See Details. |
LAST_REPORTED_DATE |
e.g. '11-JAN-05'. See Details. |
CREATE_DATE |
e.g. '02-JUN-02'. See Details. |
UPDATE_DATE |
e.g. '20-JAN-05'. See Details. |
SENSITIVE_IND |
e.g. 'N'. See Details. |
USER_ID |
e.g. 'REFRESH_ORG_UPD'. See Details. |
PUBLIC_IND |
e.g. 'Y'. See Details. |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.