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


VIEW: APPS.IGI_EXP_AVAILABLE_TRX_V

Object Details
Object Name: IGI_EXP_AVAILABLE_TRX_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGI.IGI_EXP_AVAILABLE_TRX_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
APPLICATION VARCHAR2 (240)
Name of application
TRANSACTION_TYPE_DESC VARCHAR2 (80)
TRANSACTION_NUMBER VARCHAR2 (50)
DESCRIPTION VARCHAR2 (240)
GL_DATE DATE

THIRD_PARTY VARCHAR2 (360)
THIRD_PARTY_SITE VARCHAR2 (40)
AMOUNT NUMBER

APPLICATION_ID NUMBER

TRANSACTION_TYPE VARCHAR2 (25)
THIRD_PARTY_ID NUMBER (15)
THIRD_PARTY_SITE_ID NUMBER (15)
CURRENCY_CODE VARCHAR2 (15)
ORG_ID NUMBER (15)
INVOICE_ID NUMBER

CUSTOMER_TRX_ID NUMBER

Query Text

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


SELECT APPLICATION
,      TRANSACTION_TYPE_DESC
,      TRANSACTION_NUMBER
,      DESCRIPTION
,      GL_DATE
,      THIRD_PARTY
,      THIRD_PARTY_SITE
,      AMOUNT
,      APPLICATION_ID
,      TRANSACTION_TYPE
,      THIRD_PARTY_ID
,      THIRD_PARTY_SITE_ID
,      CURRENCY_CODE
,      ORG_ID
,      INVOICE_ID
,      CUSTOMER_TRX_ID
FROM APPS.IGI_EXP_AVAILABLE_TRX_V;

Dependencies

[top of page]

APPS.IGI_EXP_AVAILABLE_TRX_V references the following:

SchemaAPPS
SynonymAP_HOLDS
PL/SQL PackageAP_INVOICES_PKG - show dependent code
PL/SQL PackageAP_INVOICES_UTILITY_PKG - show dependent code
ViewAP_INVOICES_V
PL/SQL PackageAP_PREPAY_UTILS_PKG - show dependent code
PL/SQL PackageARH_ADDR_PKG - show dependent code
PL/SQL PackageARPT_SQL_FUNC_UTIL - show dependent code
ViewFND_APPLICATION_VL
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageFND_USER_AP_PKG - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymIGI_EXP_AP_TRANS
SynonymIGI_EXP_AR_TRANS
ViewIGI_EXP_AR_TRX_AMOUNTS_V
PL/SQL PackagePA_TASK_UTILS - show dependent code
PL/SQL PackagePA_UTILS4 - show dependent code
ViewRA_CUSTOMER_TRX_V

APPS.IGI_EXP_AVAILABLE_TRX_V is not referenced by any database object