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

VIEW: IGI.IGI_ARC_DRILL_ITF#

Object Details
Object Name: IGI_ARC_DRILL_ITF#
Object Type: VIEW
Owner: IGI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15) Yes
JOURNAL_LINE_NUMBER NUMBER (15) Yes
ACCOUNT_CODE VARCHAR2 (929) Yes
ACCOUNT_DESC VARCHAR2 (929)
TRX_TYPE_NAME VARCHAR2 (80)
TRX_NUMBER VARCHAR2 (30)
TRX_DATE DATE

THIRD_PARTY_NAME VARCHAR2 (360)
ACCOUNTED_DR NUMBER

ACCOUNTED_CR NUMBER

CURRENCY_CODE VARCHAR2 (15)
ACCT_LINE_TYPE_NAME VARCHAR2 (80)
BANK_ACCOUNT_NAME VARCHAR2 (80)
PAYMENT_DEPOSIT_DATE DATE

APPLIED_TO_TRX_NUMBER VARCHAR2 (20)
APPLICATION_DATE DATE

REVERSAL_DATE DATE

ACCOUNTING_DATE DATE

FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
ORGANIZATION_NAME VARCHAR2 (240)
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
Query Text

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


SELECT REQUEST_ID
,      JOURNAL_LINE_NUMBER
,      ACCOUNT_CODE
,      ACCOUNT_DESC
,      TRX_TYPE_NAME
,      TRX_NUMBER
,      TRX_DATE
,      THIRD_PARTY_NAME
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      CURRENCY_CODE
,      ACCT_LINE_TYPE_NAME
,      BANK_ACCOUNT_NAME
,      PAYMENT_DEPOSIT_DATE
,      APPLIED_TO_TRX_NUMBER
,      APPLICATION_DATE
,      REVERSAL_DATE
,      ACCOUNTING_DATE
,      FUNCTIONAL_CURRENCY_CODE
,      ORGANIZATION_NAME
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM IGI.IGI_ARC_DRILL_ITF#;

Dependencies

[top of page]

IGI.IGI_ARC_DRILL_ITF# references the following:

SchemaIGI
TableIGI_ARC_DRILL_ITF
IGI.IGI_ARC_DRILL_ITF# is referenced by following:

SchemaAPPS
SynonymIGI_ARC_DRILL_ITF