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.IGI_STP_SITE_BAL

Object Details

Object Name:	IGI_STP_SITE_BAL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGI.IGI_STP_SITE_BAL
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

View lists single third party site information

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
STP_ID	NUMBER	(15)	Yes	Single third party identifier
ADDRESS_ID	NUMBER	(15)	Yes	Receivables Address identifier
ADDRESS_NAME	VARCHAR2	(100)		Receivable Address name
VENDOR_ID	NUMBER		Yes	Supplier identifier
VENDOR_SITE_ID	NUMBER		Yes	Supplier site identifier
ORG_ID	NUMBER	(15)		organization Identifier

Query Text

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


SELECT STP_ID
,      ADDRESS_ID
,      ADDRESS_NAME
,      VENDOR_ID
,      VENDOR_SITE_ID
,      ORG_ID
FROM APPS.IGI_STP_SITE_BAL;

Dependencies

[top of page]

APPS.IGI_STP_SITE_BAL references the following:

APPS: AP_SUPPLIER_SITES; HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES_ALL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES; IGI_PO_VENDORS; IGI_RA_ADDRESSES

APPS.IGI_STP_SITE_BAL is not referenced by any database object