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

VIEW: IGI.IGI_INT_LINES#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
RECORD_TYPE VARCHAR2 (2) Yes
INTERFACE_HEADER_ID NUMBER
Yes
AMOUNT NUMBER
Yes
PRIMARY_DESCRIPTION VARCHAR2 (240) Yes
TRANSACTION_DATE VARCHAR2 (240)
DESCRIPTOR1 VARCHAR2 (240)
DESCRIPTOR2 VARCHAR2 (240)
DESCRIPTOR3 VARCHAR2 (240)
DESCRIPTOR4 VARCHAR2 (240)
DESCRIPTOR5 VARCHAR2 (240)
DESCRIPTOR6 VARCHAR2 (240)
DESCRIPTOR7 VARCHAR2 (240)
ACCOUNT_SEGMENT1 VARCHAR2 (30)
ACCOUNT_SEGMENT2 VARCHAR2 (30)
ACCOUNT_SEGMENT3 VARCHAR2 (30)
ACCOUNT_SEGMENT4 VARCHAR2 (30)
ACCOUNT_SEGMENT5 VARCHAR2 (30)
ACCOUNT_SEGMENT6 VARCHAR2 (30)
ACCOUNT_SEGMENT7 VARCHAR2 (30)
ACCOUNT_SEGMENT8 VARCHAR2 (30)
ACCOUNT_SEGMENT9 VARCHAR2 (30)
ACCOUNT_SEGMENT10 VARCHAR2 (30)
ACCOUNT_SEGMENT11 VARCHAR2 (30)
ACCOUNT_SEGMENT12 VARCHAR2 (30)
ACCOUNT_SEGMENT13 VARCHAR2 (30)
ACCOUNT_SEGMENT14 VARCHAR2 (30)
ACCOUNT_SEGMENT15 VARCHAR2 (30)
ACCOUNT_SEGMENT16 VARCHAR2 (30)
ACCOUNT_SEGMENT17 VARCHAR2 (30)
ACCOUNT_SEGMENT18 VARCHAR2 (30)
ACCOUNT_SEGMENT19 VARCHAR2 (30)
ACCOUNT_SEGMENT20 VARCHAR2 (30)
ACCOUNT_SEGMENT21 VARCHAR2 (30)
ACCOUNT_SEGMENT22 VARCHAR2 (30)
ACCOUNT_SEGMENT23 VARCHAR2 (30)
ACCOUNT_SEGMENT24 VARCHAR2 (30)
ACCOUNT_SEGMENT25 VARCHAR2 (30)
ACCOUNT_SEGMENT26 VARCHAR2 (30)
ACCOUNT_SEGMENT27 VARCHAR2 (30)
ACCOUNT_SEGMENT28 VARCHAR2 (30)
ACCOUNT_SEGMENT29 VARCHAR2 (30)
ACCOUNT_SEGMENT30 VARCHAR2 (30)
Query Text

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


SELECT RECORD_TYPE
,      INTERFACE_HEADER_ID
,      AMOUNT
,      PRIMARY_DESCRIPTION
,      TRANSACTION_DATE
,      DESCRIPTOR1
,      DESCRIPTOR2
,      DESCRIPTOR3
,      DESCRIPTOR4
,      DESCRIPTOR5
,      DESCRIPTOR6
,      DESCRIPTOR7
,      ACCOUNT_SEGMENT1
,      ACCOUNT_SEGMENT2
,      ACCOUNT_SEGMENT3
,      ACCOUNT_SEGMENT4
,      ACCOUNT_SEGMENT5
,      ACCOUNT_SEGMENT6
,      ACCOUNT_SEGMENT7
,      ACCOUNT_SEGMENT8
,      ACCOUNT_SEGMENT9
,      ACCOUNT_SEGMENT10
,      ACCOUNT_SEGMENT11
,      ACCOUNT_SEGMENT12
,      ACCOUNT_SEGMENT13
,      ACCOUNT_SEGMENT14
,      ACCOUNT_SEGMENT15
,      ACCOUNT_SEGMENT16
,      ACCOUNT_SEGMENT17
,      ACCOUNT_SEGMENT18
,      ACCOUNT_SEGMENT19
,      ACCOUNT_SEGMENT20
,      ACCOUNT_SEGMENT21
,      ACCOUNT_SEGMENT22
,      ACCOUNT_SEGMENT23
,      ACCOUNT_SEGMENT24
,      ACCOUNT_SEGMENT25
,      ACCOUNT_SEGMENT26
,      ACCOUNT_SEGMENT27
,      ACCOUNT_SEGMENT28
,      ACCOUNT_SEGMENT29
,      ACCOUNT_SEGMENT30
FROM IGI.IGI_INT_LINES#;

Dependencies

[top of page]

IGI.IGI_INT_LINES# references the following:

SchemaIGI
TableIGI_INT_LINES
IGI.IGI_INT_LINES# is referenced by following:

SchemaAPPS
SynonymIGI_INT_LINES