[Home] [Help] [Dependency Information]
Object Name: | ITG_REQ_VENDOR_SITES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ITG.ITG_REQ_VENDOR_SITES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is used to generate XML segment containing requistion supplier location information
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUISITION_LINE_ID | NUMBER | Yes | ||
VENDOR_ID | NUMBER | |||
VENDOR_SITE_ID | NUMBER | |||
SUPPLIER_ADDR_LINE1 | VARCHAR2 | (240) | ||
SUPPLIER_ADDR_LINE2 | VARCHAR2 | (240) | ||
SUPPLIER_ADDR_LINE3 | VARCHAR2 | (240) | ||
SUPPLIER_ADDR_CITY | VARCHAR2 | (25) | ||
SUPPLIER_ADDR_COUNTRY | VARCHAR2 | (25) | ||
SUPPLIER_ADDR_COUNTY | VARCHAR2 | (150) | ||
SUPPLIER_ADDR_DESCRIPTN | VARCHAR2 | (15) | ||
SUPPLIER_ADDR_FAX | VARCHAR2 | (11) | ||
SUPPLIER_ADDR_POSTALCODE | VARCHAR2 | (20) | ||
SUPPLIER_ADDR_STATEPROVN | VARCHAR2 | (150) | ||
SUPPLIER_ADDR_UA_VATCODE | VARCHAR2 | (0) | ||
SUPPLIER_ADDR_UA_PURSITE | VARCHAR2 | (1) | ||
SUPPLIER_ADDR_UA_PAYSITE | VARCHAR2 | (1) | ||
SUPPLIER_ADDR_UA_RFQSITE | VARCHAR2 | (1) | ||
SUPPLIER_ADDR_UA_PCSITE | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT REQUISITION_LINE_ID
, VENDOR_ID
, VENDOR_SITE_ID
, SUPPLIER_ADDR_LINE1
, SUPPLIER_ADDR_LINE2
, SUPPLIER_ADDR_LINE3
, SUPPLIER_ADDR_CITY
, SUPPLIER_ADDR_COUNTRY
, SUPPLIER_ADDR_COUNTY
, SUPPLIER_ADDR_DESCRIPTN
, SUPPLIER_ADDR_FAX
, SUPPLIER_ADDR_POSTALCODE
, SUPPLIER_ADDR_STATEPROVN
, SUPPLIER_ADDR_UA_VATCODE
, SUPPLIER_ADDR_UA_PURSITE
, SUPPLIER_ADDR_UA_PAYSITE
, SUPPLIER_ADDR_UA_RFQSITE
, SUPPLIER_ADDR_UA_PCSITE
FROM APPS.ITG_REQ_VENDOR_SITES_V;
APPS.ITG_REQ_VENDOR_SITES_V is not referenced by any database object
|
|
|