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_PACKAGES_V

Object Details

Object Name:	IGI_STP_PACKAGES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGI.IGI_STP_PACKAGES_V
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.

IGI_STP_PACKAGES_V is a multiple-organizations view that displays information on single third party netting batch transactions.

[View Source]

Columns

Name	Datatype	Length	Comments
ORG_ID	NUMBER		Organization ID
ROW_ID	ROWID	(10)	Row ID
BATCH_ID	NUMBER		Batch ID
PACKAGE_ID	NUMBER		Package ID
PACKAGE_NUM	NUMBER		Package number
CUSTOMER_NAME	VARCHAR2	(50)	Customer name
STP_ID	NUMBER		Single third party ID
SITE_CODE	VARCHAR2	(40)	Site code
APPLICATION	VARCHAR2	(2)	Application, Payables (AP) or Receivables (AR)
APPLICATION_NAME	VARCHAR2	(240)	Application name
ACCOUNTING_DATE	DATE		Accounting date
TRX_NUMBER	VARCHAR2	(20)	Transaction number
RELATED_TRX_NUMBER	VARCHAR2	(20)	Related transaction number
REFERENCE	VARCHAR2	(20)	Reference
NETTING_TRX_TYPE	VARCHAR2	(80)	Netting transaction type
DOCUMENT_TRX_TYPE	CHAR	(30)	Document transaction type
AMOUNT	NUMBER		Amount
CURRENCY_CODE	VARCHAR2	(15)	Currency code
EXCHANGE_RATE_TYPE	VARCHAR2	(30)	Conversion type for converting foreign currency transactions
EXCHANGE_RATE	NUMBER		Exchange rate for converting foreign currency into functional currency
EXCHANGE_DATE	DATE		The exchange rate date
USER_RATE_TYPE	VARCHAR2	(30)	User rate type
CREATED_BY	NUMBER	(15)	Standard who column
CREATION_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Standard Who column
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard Who column

Query Text

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


SELECT ORG_ID
,      ROW_ID
,      BATCH_ID
,      PACKAGE_ID
,      PACKAGE_NUM
,      CUSTOMER_NAME
,      STP_ID
,      SITE_CODE
,      APPLICATION
,      APPLICATION_NAME
,      ACCOUNTING_DATE
,      TRX_NUMBER
,      RELATED_TRX_NUMBER
,      REFERENCE
,      NETTING_TRX_TYPE
,      DOCUMENT_TRX_TYPE
,      AMOUNT
,      CURRENCY_CODE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      EXCHANGE_DATE
,      USER_RATE_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGI_STP_PACKAGES_V;

Dependencies

[top of page]

APPS.IGI_STP_PACKAGES_V references the following:

APPS: AP_LOOKUP_CODES; AP_SUPPLIER_SITES_ALL; FND_APPLICATION_VL; FND_GLOBAL - show dependent code; GL_DAILY_CONVERSION_TYPES; HZ_CUST_ACCOUNTS; HZ_CUST_SITE_USES; HZ_PARTIES; IGI_LOOKUPS; IGI_PO_VENDORS; IGI_STP_NET_TYPE_ALLOC; IGI_STP_PACKAGES; RA_CUST_TRX_TYPES

APPS.IGI_STP_PACKAGES_V is not referenced by any database object