[Home] [Help] [Dependency Information]
Object Name: | OKX_INSURANCE_AGENT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKX.OKX_INSURANCE_AGENT_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTY_ID | NUMBER | (15) | Yes | Party identifier |
ID2 | CHAR | (1) | Reserved for future use. | |
PARTY_NAME | VARCHAR2 | (360) | Yes | Name of this party. |
PARTY_NUMBER | VARCHAR2 | (30) | Yes | Unique identification number for this party |
CATEGORY_CODE | VARCHAR2 | (30) | User-definable category. Lookup type is CUSTOMER_CATEGORY. | |
ADDRESS1 | VARCHAR2 | (240) | First line of the identifying address. | |
ADDRESS2 | VARCHAR2 | (240) | Second line of the identifying address. | |
ADDRESS3 | VARCHAR2 | (240) | Third line of the identifying address. | |
ADDRESS4 | VARCHAR2 | (240) | Fourth line of the identifying address. | |
CITY | VARCHAR2 | (60) | City of the identifying address. | |
POSTAL_CODE | VARCHAR2 | (60) | Code of the identifying address | |
STATE | VARCHAR2 | (60) | State of the identifying address | |
COUNTRY | VARCHAR2 | (60) | Country of the identifying address. | |
PROVINCE | VARCHAR2 | (60) | Province of the identifying address. | |
STATUS | VARCHAR2 | (1) | Yes | Party status flag. |
COUNTY | VARCHAR2 | (60) | County of the identifying address. | |
THIRD_PARTY_FLAG | VARCHAR2 | (1) | Tracks if a party has a direct relationship with the organization using Oracle Receivables or through a third party vendor. Y for a third party relationship, N for a direct relationship. If Oracle Service is installed, the Third Party field in the Customers window is mandatory. | |
FIRST_NAME | VARCHAR2 | (150) | First name of the person. | |
MIDDLE_NAME | VARCHAR2 | (60) | Middle name of the person | |
LAST_NAME | VARCHAR2 | (150) | Last name of the person | |
TITLE | VARCHAR2 | (60) | A professional or family title. For example, Don or The Right Honorable. | |
ACADEMIC_TITLE | VARCHAR2 | (30) | Academic title that is part of a person's name, such as Dr. John Smith. | |
EMAIL_ADDRESS | VARCHAR2 | (2000) | E- mail address. | |
ADDRESS | VARCHAR2 | (1329) | Identifying address. | |
AGENT_SITE_ID | NUMBER | (15) | Yes | Agent party site identifier. |
AGENT_TYPE | CHAR | (11) | Not used. |
Cut, paste (and edit) the following text to query this object:
SELECT PARTY_ID
, ID2
, PARTY_NAME
, PARTY_NUMBER
, CATEGORY_CODE
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, POSTAL_CODE
, STATE
, COUNTRY
, PROVINCE
, STATUS
, COUNTY
, THIRD_PARTY_FLAG
, FIRST_NAME
, MIDDLE_NAME
, LAST_NAME
, TITLE
, ACADEMIC_TITLE
, EMAIL_ADDRESS
, ADDRESS
, AGENT_SITE_ID
, AGENT_TYPE
FROM APPS.OKX_INSURANCE_AGENT_V;
|
|
|