[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_OR_ADDR |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_OR_ADDR
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
IGS_OR_ADDR is used to capture the details of address
| ROW_ID | ROWID | (10) | Uniquely identifies a row | |
| ORG_UNIT_CD | VARCHAR2 | (30) | Organization unit code that uniquely identifies an organization | |
| OU_START_DT | DATE | Start date of an organization unit association | ||
| START_DT | DATE | Start Date of the Address used by the person, being selected from IGS extension table | ||
| END_DT | DATE | End Date of the Address used by the person, being selected from IGS extension table | ||
| ADDR_TYPE | VARCHAR2 | (30) | Address type of an address, for example, Postal or e-mail | |
| ADDR_LINE_1 | VARCHAR2 | (240) | Yes | First line of address |
| ADDR_LINE_2 | VARCHAR2 | (240) | Second line of address | |
| ADDR_LINE_3 | VARCHAR2 | (240) | Third line of address | |
| ADDR_LINE_4 | VARCHAR2 | (240) | Fourth line of address | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| DATE_LAST_VERIFIED | DATE | Obsolete | ||
| CORRESPONDENCE_IND | VARCHAR2 | (1) | Yes | Indicates if the address is a correspondence address or not |
| CITY | VARCHAR2 | (60) | Captures the 'City' of address | |
| STATE | VARCHAR2 | (60) | Captures the address for a particular address type | |
| PROVINCE | VARCHAR2 | (60) | Captures the address for a particular address type | |
| COUNTY | VARCHAR2 | (60) | Captures the address for a particular address type | |
| COUNTRY | VARCHAR2 | (60) | Yes | Captures the address for a particular address type |
| POSTAL_CODE | VARCHAR2 | (60) | Captures the address for a particular address type | |
| DELIVERY_POINT_CODE | VARCHAR2 | (50) | Captures the address for a particular address type | |
| OTHER_DETAILS_1 | VARCHAR2 | (0) | Obsolete | |
| OTHER_DETAILS_2 | VARCHAR2 | (0) | Obsolete | |
| OTHER_DETAILS_3 | VARCHAR2 | (0) | Obsolete | |
| REQUEST_ID | NUMBER | (15) | Request identifier of last concurrent program to update this record | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Application identifier of last concurrent program to update this record | |
| PROGRAM_ID | NUMBER | (15) | Program identifier of last concurrent program to update this record | |
| PROGRAM_UPDATE_DATE | DATE | Last update date of this record by a concurrent program | ||
| STATUS | VARCHAR2 | (1) | Yes | Status, Active or Inactive, of the Party Site |
| Name | Datatype | Length | Mandatory | Comments |
|---|
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ORG_UNIT_CD
, OU_START_DT
, START_DT
, END_DT
, ADDR_TYPE
, ADDR_LINE_1
, ADDR_LINE_2
, ADDR_LINE_3
, ADDR_LINE_4
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DATE_LAST_VERIFIED
, CORRESPONDENCE_IND
, CITY
, STATE
, PROVINCE
, COUNTY
, COUNTRY
, POSTAL_CODE
, DELIVERY_POINT_CODE
, OTHER_DETAILS_1
, OTHER_DETAILS_2
, OTHER_DETAILS_3
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, STATUS
FROM APPS.IGS_OR_ADDR;
APPS
HZ_LOCATIONS
HZ_PARTY_SITES
HZ_PARTY_SITE_USES
IGS_OR_INST_ORG_BASE_V
IGS_PE_HZ_PTY_SITES
APPS
IGS_GE_GEN_001
- show dependent code
IGS_GE_GEN_002
- show dependent code
IGS_OR_ADDR_PKG
- show dependent code
IGS_OR_VAL_OA
- show dependent code
|
|
|
|