[Home] [Help] [Dependency Information]
Object Name: | IGS_DA_XML_PERSON_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_DA_XML_PERSON_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
XML element PersonType
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_CODE_QUALIFIER | VARCHAR2 | (10) | Contains a value indicating the type of PersonIdCode being passed. | |
PERSON_ID_CODE | VARCHAR2 | (30) | Contains the value of the Person ID | |
NAME_TYPE | VARCHAR2 | (30) | Contains a value indicating the type of PersonName being passed. | |
NAME_TITLE | VARCHAR2 | (30) | Contains the title of the person. | |
NAME_FIRST | VARCHAR2 | (150) | Contains the first name of the person. | |
NAME_MIDDLE | VARCHAR2 | (60) | Contains the middle name of the person. | |
NAME_LAST | VARCHAR2 | (150) | Contains the surname of the person. | |
NAME_SUFFIX | VARCHAR2 | (30) | Contains the suffix of the person. | |
ADDRESS_TYPE | VARCHAR2 | (30) | Contains a value indicating the type of address. | |
ADDRESS_LINE_1 | VARCHAR2 | (240) | Contains the first line of the address. | |
ADDRESS_LINE_2 | VARCHAR2 | (240) | Contains the second line of the address | |
ADDRESS_LINE_3 | VARCHAR2 | (240) | Contains the third line of the address. | |
ADDRESS_LINE_4 | VARCHAR2 | (240) | Contains the fourth line of the address. | |
ADDRESS_CITY | VARCHAR2 | (60) | Contains the city of the address. | |
ADDRESS_STATE_PROVINCE | VARCHAR2 | (120) | Contains the state or province of the address. | |
ADDRESS_POSTAL_CODE | VARCHAR2 | (60) | Contains the postal code of the address. | |
ADDRESS_COUNTRY | VARCHAR2 | (60) | Contains the country of the address. | |
BATCH_ID | NUMBER | Contains the OSS generated Batch ID for tracking purposes. | ||
PERSON_ID | NUMBER | (15) | Describes the details of the person ID code that is being passed. |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_CODE_QUALIFIER
, PERSON_ID_CODE
, NAME_TYPE
, NAME_TITLE
, NAME_FIRST
, NAME_MIDDLE
, NAME_LAST
, NAME_SUFFIX
, ADDRESS_TYPE
, ADDRESS_LINE_1
, ADDRESS_LINE_2
, ADDRESS_LINE_3
, ADDRESS_LINE_4
, ADDRESS_CITY
, ADDRESS_STATE_PROVINCE
, ADDRESS_POSTAL_CODE
, ADDRESS_COUNTRY
, BATCH_ID
, PERSON_ID
FROM APPS.IGS_DA_XML_PERSON_V;
|
|
|