[Home] [Help] [Dependency Information]

VIEW: APPS.ITG_REQ_VENDOR_SITES_V

Object Details

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

View Type

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

[View Source]

Columns

Query Text

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;

Dependencies

[top of page]

APPS

FND_GLOBAL - show dependent code

PO_REQUISITION_LINES_ALL

PO_VENDOR_SITES_ALL

APPS.ITG_REQ_VENDOR_SITES_V is not referenced by any database object