eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGS_FI_PARTY_VENDRS_V

Object Details

Object Name:	IGS_FI_PARTY_VENDRS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_FI_PARTY_VENDRS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		The Row Identifier.
PARTY_ID	NUMBER	(15)	Yes	The Party Identifier in Oracle Student System.
PARTY_NUMBER	VARCHAR2	(30)	Yes	The Party Number of the party.
FULL_NAME	VARCHAR2	(450)		The Full Name of the party.
API_PERSON_ID	VARCHAR2	(20)		The Alternate person identifier.
VENDOR_ID	NUMBER		Yes	The Supplier Identifier in Oracle Payables that would be associated to the Party in Oracle Student System.
VENDOR_NUMBER	VARCHAR2	(30)	Yes	The Supplier Number of the supplier.
VENDOR_NAME	VARCHAR2	(240)		The Supplier Name of the supplier.
VENDOR_SITE_ID	NUMBER		Yes	The Supplier Site Identifier of the supplier in Oracle Payables that would be associated to the Party in Oracle Student System.
VENDOR_SITE_CODE	VARCHAR2	(15)	Yes	The Supplier Site Name of the supplier.
CREATION_DATE	DATE		Yes	Standard WHO Column.
CREATED_BY	NUMBER	(15)	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.
REQUEST_ID	NUMBER	(15)		Standard Concurrent Program WHO Column.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Concurrent Program WHO Column.
PROGRAM_ID	NUMBER	(15)		Standard Concurrent Program WHO Column.
PROGRAM_UPDATE_DATE	DATE			Standard Concurrent Program WHO Column.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      PARTY_ID
,      PARTY_NUMBER
,      FULL_NAME
,      API_PERSON_ID
,      VENDOR_ID
,      VENDOR_NUMBER
,      VENDOR_NAME
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.IGS_FI_PARTY_VENDRS_V;

Dependencies

[top of page]

APPS.IGS_FI_PARTY_VENDRS_V references the following:

APPS: IGS_EN_GEN_003 - show dependent code; IGS_FI_PARTIES_V; IGS_FI_PARTY_VENDRS; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.IGS_FI_PARTY_VENDRS_V is not referenced by any database object