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

VIEW: APPS.IGI_EXP_TRAN_UNIT_V

Object Details
Object Name: IGI_EXP_TRAN_UNIT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGI.IGI_EXP_TRAN_UNIT_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)
Row identifier
TRANS_UNIT_ID NUMBER
Yes Transmission Unit identifier
TRANS_UNIT_NUM VARCHAR2 (80) Yes Transmission unit number
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
AMOUNT NUMBER

Amount
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
USER_NAME VARCHAR2 (100) Yes User name
APPLICATION VARCHAR2 (2) Yes Application, Payables (AP) or Receivables (AR)
DOC_TYPE_ID NUMBER (30) Yes Document type identifier
STATUS VARCHAR2 (80) Yes Status
Query Text

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


SELECT ROW_ID
,      TRANS_UNIT_ID
,      TRANS_UNIT_NUM
,      CREATION_DATE
,      AMOUNT
,      CREATED_BY
,      USER_NAME
,      APPLICATION
,      DOC_TYPE_ID
,      STATUS
FROM APPS.IGI_EXP_TRAN_UNIT_V;

Dependencies

[top of page]

APPS.IGI_EXP_TRAN_UNIT_V references the following:

SchemaAPPS
SynonymFND_USER
ViewIGI_EXP_TRAN_UNIT_DEF
SynonymIGI_EXP_TRX_TYPE
ViewIGI_LOOKUPS
ViewPO_VENDORS

APPS.IGI_EXP_TRAN_UNIT_V is not referenced by any database object