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_EXP_TRAN_UNIT_DEF

Object Details

Object Name:	IGI_EXP_TRAN_UNIT_DEF
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGI.IGI_EXP_TRAN_UNIT_DEF
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_EXP_TRAN_UNIT_DEF displays information about Echange Protocol transmission units.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TRANS_UNIT_ID	NUMBER		Yes	Transmission unit identifier
TRANS_UNIT_NUM	VARCHAR2	(80)	Yes	Transmission unit number
DOC_TYPE_ID	NUMBER	(30)	Yes	Document type identifier
ACT_NUMBER	VARCHAR2	(80)	Yes	Act number
TRANS_UNIT_STATUS	VARCHAR2	(30)	Yes	Status of transmission unit. Values are SEL for selected, TRA for transmitted and TER for terminated
TRANS_UNIT_NUM_TYPE	VARCHAR2	(30)	Yes	Transmission unit type, Act or Legal
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ORG_ID	NUMBER			Organization identifier
LEGAL_NUMBER	VARCHAR2	(80)		Legal number
MRC_EXCHANGE_RATE_TYPE	VARCHAR2	(2000)		Exchange rate type for a foreign currency invoice in Multi-Reporting Currencies (MRC) defined reporting currency
THIRD_PARTY_ID	NUMBER			Single third party identifier
TRAN_UNIT_CALL_NUM	NUMBER			Transmission unit call number
AMOUNT	NUMBER			Amount
MRC_AMOUNT	VARCHAR2	(2000)		Invoice distribution amount in Multi-Reporting Currencies (MRC) defined reporting currency
MRC_EXCHANGE_RATE	VARCHAR2	(2000)		Exchange rate for a foreign currency invoice in Multi-Reporting Currencies (MRC) defined reporting currency
MRC_EXCHANGE_DATE	VARCHAR2	(2000)		Date exchange rate is obtained from daily rates table in Multi-Reporting Currencies (MRC) defined reporting currency
MRC_AMOUNT_EXCHANGE_RATE_TYPE	VARCHAR2	(2000)		Exchange rate type for a foreign currency invoice in Multi-Reporting Currencies (MRC) defined reporting currency
PRINT_DATE	DATE			Print date
UPGRADE_STATUS	VARCHAR2	(1)		Indicates whether Transmission Unit has been migrated to new version.

Query Text

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


SELECT TRANS_UNIT_ID
,      TRANS_UNIT_NUM
,      DOC_TYPE_ID
,      ACT_NUMBER
,      TRANS_UNIT_STATUS
,      TRANS_UNIT_NUM_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ORG_ID
,      LEGAL_NUMBER
,      MRC_EXCHANGE_RATE_TYPE
,      THIRD_PARTY_ID
,      TRAN_UNIT_CALL_NUM
,      AMOUNT
,      MRC_AMOUNT
,      MRC_EXCHANGE_RATE
,      MRC_EXCHANGE_DATE
,      MRC_AMOUNT_EXCHANGE_RATE_TYPE
,      PRINT_DATE
,      UPGRADE_STATUS
FROM APPS.IGI_EXP_TRAN_UNIT_DEF;

Dependencies

[top of page]

APPS.IGI_EXP_TRAN_UNIT_DEF references the following:

APPS: IGI_EXP_TRAN_UNIT_DEF_ALL

APPS.IGI_EXP_TRAN_UNIT_DEF is referenced by following:

APPS: IGI_EXP_CUSTOM - show dependent code; IGI_EXP_EPTU_TRANS_V; IGI_EXP_TRAN_UNIT_V