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: IGI.IGI_STP_PACKAGES_ALL#

Object Details

Object Name:	IGI_STP_PACKAGES_ALL#
Object Type:	VIEW
Owner:	IGI
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_ALL is a multi-org view which displays information on Single Third Party netting batch transactions.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER		Yes	Batch identifier
PACKAGE_ID	NUMBER		Yes	Package identifier
STP_ID	NUMBER		Yes	Single third party identifier
SITE_ID	NUMBER		Yes	Site identifier
APPLICATION	VARCHAR2	(2)	Yes	Application, Payables (AP) or Receivables (AR)
AMOUNT	NUMBER		Yes	Amount
ACCOUNTING_DATE	DATE		Yes	Accounting date
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ORG_ID	NUMBER			Organization identifier
MRC_AMOUNT	NUMBER			Invoice distribution amount in Multi-Reporting Currencies (MRC) defined reporting currency
MRC_EXCHANGE_RATE	NUMBER			Exchange rate for a foreign currency invoice in Multi-Reporting Currencies (MRC) defined reporting currency
MRC_EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate type for a foreign currency invoice in Multi-Reporting Currencies (MRC) defined reporting currency
MRC_EXCHANGE_DATE	DATE			Date exchange rate is obtained from daily rates table in Multi-Reporting Currencies defined reporting currency
MRC_EXCHANGE_STATUS	VARCHAR2	(30)		Status of Multi-Reporting Currencies (MRC) exchange rate
TRX_NUMBER	VARCHAR2	(20)		Transaction number
REFERENCE	VARCHAR2	(20)		Reference
NETTING_TRX_TYPE_ID	NUMBER			Netting transaction type identifier
ACCT_PAY_CODE_COMBINATION_ID	NUMBER			Payables code combination identifier
REC_CODE_COMBINATION_ID	NUMBER			Receivables code combination identifier
TRX_TYPE_CLASS	VARCHAR2	(4)		Transaction type class
LINE_TYPE_LOOKUP_CODE	VARCHAR2	(30)		Line type lookup code
DESCRIPTION	VARCHAR2	(80)		Description
DOC_CATEGORY_CODE	VARCHAR2	(30)		Document category code
RELATED_TRX_NUMBER	VARCHAR2	(20)		Related transaction number
PACKAGE_NUM	NUMBER			Package number
TECHNICAL_CCID	NUMBER			Technical code combination identifier
REC_OR_LIAB_CCID	NUMBER			Liability code combination identifier for a Payables transaction or a Receivables identifier for a Receivables transaction
CURRENCY_CODE	VARCHAR2	(15)		Currency code
EXCHANGE_RATE	NUMBER			Exchange rate used to convert foreign currency amounts into functional currency
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Conversion type used to convert foreign currency transactions
EXCHANGE_DATE	DATE			Date for which rate is selected
IGI_STP_PACKAGES_ALL_BATCH_ID	NUMBER

Query Text

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


SELECT BATCH_ID
,      PACKAGE_ID
,      STP_ID
,      SITE_ID
,      APPLICATION
,      AMOUNT
,      ACCOUNTING_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      MRC_AMOUNT
,      MRC_EXCHANGE_RATE
,      MRC_EXCHANGE_RATE_TYPE
,      MRC_EXCHANGE_DATE
,      MRC_EXCHANGE_STATUS
,      TRX_NUMBER
,      REFERENCE
,      NETTING_TRX_TYPE_ID
,      ACCT_PAY_CODE_COMBINATION_ID
,      REC_CODE_COMBINATION_ID
,      TRX_TYPE_CLASS
,      LINE_TYPE_LOOKUP_CODE
,      DESCRIPTION
,      DOC_CATEGORY_CODE
,      RELATED_TRX_NUMBER
,      PACKAGE_NUM
,      TECHNICAL_CCID
,      REC_OR_LIAB_CCID
,      CURRENCY_CODE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      IGI_STP_PACKAGES_ALL_BATCH_ID
FROM IGI.IGI_STP_PACKAGES_ALL#;

Dependencies

[top of page]

IGI.IGI_STP_PACKAGES_ALL# references the following:

IGI: IGI_STP_PACKAGES_ALL

IGI.IGI_STP_PACKAGES_ALL# is referenced by following:

APPS: IGI_STP_PACKAGES; IGI_STP_PACKAGES_ALL