[Home] [Help] [Dependency Information]
Object Name: | POS_ADDRESS_REQUESTS |
---|---|
Object Type: | TABLE |
Owner: | POS |
FND Design Data: | POS.POS_ADDRESS_REQUESTS |
Subobject Name: | |
Status: | VALID |
POS_ADDRESS_REQUESTS stores information about supplier address requests, such as adding an address, updating an adress and removing an address.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
POS_ADDRESS_REQUEST_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ADDRESS_REQUEST_ID |
POS_ADDRESS_REQUEST_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | MAPPING_ID |
POS_ADDRESS_REQUEST_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REQUEST_TYPE |
POS_ADDRESS_REQUEST_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REQUEST_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADDRESS_REQUEST_ID | NUMBER | (15) | Yes | Address request identifier |
MAPPING_ID | NUMBER | Yes | Identifier of the supplier mapping | |
PARTY_SITE_ID | NUMBER | Identifier of the party site this request is for | ||
REQUEST_STATUS | VARCHAR2 | (30) | Yes | Status of the request |
REQUEST_TYPE | VARCHAR2 | (30) | Yes | Type of the request |
HAS_BACKING_DOC | VARCHAR2 | (1) | Flag that indicates whether this request has current backing documents | |
PARTY_SITE_NAME | VARCHAR2 | (240) | Yes | Name of the address or party site |
ADDRESS_LINE1 | VARCHAR2 | (240) | Yes | Address line 1 |
ADDRESS_LINE2 | VARCHAR2 | (240) | Address line 2 | |
ADDRESS_LINE3 | VARCHAR2 | (240) | Address line 3 | |
ADDRESS_LINE4 | VARCHAR2 | (240) | Address line 4 | |
CITY | VARCHAR2 | (60) | City | |
POSTAL_CODE | VARCHAR2 | (60) | Postal code | |
STATE | VARCHAR2 | (60) | State | |
PROVINCE | VARCHAR2 | (60) | Province | |
COUNTY | VARCHAR2 | (60) | County | |
COUNTRY | VARCHAR2 | (60) | Yes | Country |
EMAIL_ADDRESS | VARCHAR2 | (2000) | Email address | |
PHONE_AREA_CODE | VARCHAR2 | (10) | Phone area code | |
PHONE_NUMBER | VARCHAR2 | (40) | Phone number | |
PHONE_EXTENSION | VARCHAR2 | (20) | Phone extension | |
FAX_AREA_CODE | VARCHAR2 | (10) | Fax area code | |
FAX_NUMBER | VARCHAR2 | (40) | Fax number | |
RFQ_FLAG | VARCHAR2 | (1) | Flag of RFQ usage | |
PAY_FLAG | VARCHAR2 | (1) | Flag of PAY usage | |
PUR_FLAG | VARCHAR2 | (1) | Flag of Purchasing usage | |
PRIMARY_PAY_FLAG | VARCHAR2 | (1) | Flag of Primary Payment usage | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
END_DATE_ACTIVE | DATE | End active date |
Cut, paste (and edit) the following text to query this object:
SELECT ADDRESS_REQUEST_ID
, MAPPING_ID
, PARTY_SITE_ID
, REQUEST_STATUS
, REQUEST_TYPE
, HAS_BACKING_DOC
, PARTY_SITE_NAME
, ADDRESS_LINE1
, ADDRESS_LINE2
, ADDRESS_LINE3
, ADDRESS_LINE4
, CITY
, POSTAL_CODE
, STATE
, PROVINCE
, COUNTY
, COUNTRY
, EMAIL_ADDRESS
, PHONE_AREA_CODE
, PHONE_NUMBER
, PHONE_EXTENSION
, FAX_AREA_CODE
, FAX_NUMBER
, RFQ_FLAG
, PAY_FLAG
, PUR_FLAG
, PRIMARY_PAY_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, END_DATE_ACTIVE
FROM POS.POS_ADDRESS_REQUESTS;
POS.POS_ADDRESS_REQUESTS does not reference any database object
POS.POS_ADDRESS_REQUESTS is referenced by following:
|
|
|