Skip to content

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

VIEW: AX.AX_SLE_LINES#

Object Details
Object Name: AX_SLE_LINES#
Object Type: VIEW
Owner: AX
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
JOURNAL_SEQUENCE_ID NUMBER (15) Yes
SLE_HEADER_ID NUMBER
Yes
SLE_LINE_NUM NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

GL_POSTED_FLAG VARCHAR2 (1) Yes
GL_POSTED_DATE DATE

CODE_COMBINATION_ID NUMBER
Yes
ACCOUNTED_CR NUMBER

ACCOUNTED_DR NUMBER

ENTERED_CR NUMBER

ENTERED_DR NUMBER

THIRD_PARTY_ID NUMBER

SUB_ID NUMBER

COMMENT_LINE VARCHAR2 (2000)
REFERENCE_1 VARCHAR2 (240)
REFERENCE_2 VARCHAR2 (240)
REFERENCE_3 VARCHAR2 (240)
REFERENCE_4 VARCHAR2 (240)
REFERENCE_5 VARCHAR2 (240)
REFERENCE_6 VARCHAR2 (240)
REFERENCE_7 VARCHAR2 (240)
REFERENCE_8 VARCHAR2 (240)
REFERENCE_9 VARCHAR2 (240)
REFERENCE_10 VARCHAR2 (240)
REFERENCE_11 VARCHAR2 (240)
REFERENCE_12 VARCHAR2 (240)
REFERENCE_13 VARCHAR2 (240)
REFERENCE_14 VARCHAR2 (240)
REFERENCE_15 VARCHAR2 (240)
REFERENCE_16 VARCHAR2 (240)
REFERENCE_17 VARCHAR2 (240)
REFERENCE_18 VARCHAR2 (240)
REFERENCE_19 VARCHAR2 (240)
REFERENCE_20 VARCHAR2 (240)
REFERENCE_21 VARCHAR2 (240)
REFERENCE_22 VARCHAR2 (240)
REFERENCE_23 VARCHAR2 (240)
REFERENCE_24 VARCHAR2 (240)
REFERENCE_25 VARCHAR2 (240)
REFERENCE_26 VARCHAR2 (240)
REFERENCE_27 VARCHAR2 (240)
REFERENCE_28 VARCHAR2 (240)
REFERENCE_29 VARCHAR2 (240)
REFERENCE_30 VARCHAR2 (240)
REFERENCE_31 VARCHAR2 (240)
REFERENCE_32 VARCHAR2 (240)
REFERENCE_33 VARCHAR2 (240)
REFERENCE_34 VARCHAR2 (240)
REFERENCE_35 VARCHAR2 (240)
REFERENCE_36 VARCHAR2 (240)
REFERENCE_37 VARCHAR2 (240)
REFERENCE_38 VARCHAR2 (240)
REFERENCE_39 VARCHAR2 (240)
REFERENCE_40 VARCHAR2 (240)
REFERENCE_41 VARCHAR2 (240)
REFERENCE_42 VARCHAR2 (240)
REFERENCE_43 VARCHAR2 (240)
REFERENCE_44 VARCHAR2 (240)
REFERENCE_45 VARCHAR2 (240)
REFERENCE_46 VARCHAR2 (240)
REFERENCE_47 VARCHAR2 (240)
REFERENCE_48 VARCHAR2 (240)
REFERENCE_49 VARCHAR2 (240)
REFERENCE_50 VARCHAR2 (240)
REFERENCE_51 VARCHAR2 (240)
REFERENCE_52 VARCHAR2 (240)
REFERENCE_53 VARCHAR2 (240)
REFERENCE_54 VARCHAR2 (240)
REFERENCE_55 VARCHAR2 (240)
REFERENCE_56 VARCHAR2 (240)
REFERENCE_57 VARCHAR2 (240)
REFERENCE_58 VARCHAR2 (240)
REFERENCE_59 VARCHAR2 (240)
REFERENCE_60 VARCHAR2 (240)
ORG_ID NUMBER (15)
BALANCE_FLAG VARCHAR2 (1)
CURRENCY_CODE VARCHAR2 (15)
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_RATE NUMBER

REFERENCE_NUM1 NUMBER

REFERENCE_NUM2 NUMBER

REFERENCE_NUM3 NUMBER

REFERENCE_NUM4 NUMBER

REFERENCE_NUM5 NUMBER

REFERENCE_NUM6 NUMBER

REFERENCE_NUM7 NUMBER

REFERENCE_NUM8 NUMBER

REFERENCE_NUM9 NUMBER

REFERENCE_NUM10 NUMBER

REFERENCE_DATE1 DATE

REFERENCE_DATE2 DATE

REFERENCE_DATE3 DATE

REFERENCE_DATE4 DATE

REFERENCE_DATE5 DATE

REFERENCE_DATE6 DATE

REFERENCE_DATE7 DATE

REFERENCE_DATE8 DATE

REFERENCE_DATE9 DATE

REFERENCE_DATE10 DATE

SOURCE_ID NUMBER (15)
SOURCE_TABLE VARCHAR2 (30)
APPLIED_FROM_DOC_ENTITY VARCHAR2 (30)
APPLIED_FROM_DOC_ID NUMBER (15)
APPLIED_TO_DOC_ENTITY VARCHAR2 (30)
APPLIED_TO_DOC_ID NUMBER (15)
TAX_CODE_ID NUMBER (15)
LOCATION_SEGMENT_ID NUMBER (15)
TAXABLE_ENTERED_DR NUMBER

TAXABLE_ENTERED_CR NUMBER

TAXABLE_ACCOUNTED_DR NUMBER

TAXABLE_ACCOUNTED_CR NUMBER

STAT_AMOUNT NUMBER

LINE_TYPE VARCHAR2 (30)
GL_TRANSFER_LINE_NUM NUMBER

APPLICATION_ID NUMBER
Yes
SET_OF_BOOKS_ID NUMBER
Yes
Query Text

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


SELECT JOURNAL_SEQUENCE_ID
,      SLE_HEADER_ID
,      SLE_LINE_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      GL_POSTED_FLAG
,      GL_POSTED_DATE
,      CODE_COMBINATION_ID
,      ACCOUNTED_CR
,      ACCOUNTED_DR
,      ENTERED_CR
,      ENTERED_DR
,      THIRD_PARTY_ID
,      SUB_ID
,      COMMENT_LINE
,      REFERENCE_1
,      REFERENCE_2
,      REFERENCE_3
,      REFERENCE_4
,      REFERENCE_5
,      REFERENCE_6
,      REFERENCE_7
,      REFERENCE_8
,      REFERENCE_9
,      REFERENCE_10
,      REFERENCE_11
,      REFERENCE_12
,      REFERENCE_13
,      REFERENCE_14
,      REFERENCE_15
,      REFERENCE_16
,      REFERENCE_17
,      REFERENCE_18
,      REFERENCE_19
,      REFERENCE_20
,      REFERENCE_21
,      REFERENCE_22
,      REFERENCE_23
,      REFERENCE_24
,      REFERENCE_25
,      REFERENCE_26
,      REFERENCE_27
,      REFERENCE_28
,      REFERENCE_29
,      REFERENCE_30
,      REFERENCE_31
,      REFERENCE_32
,      REFERENCE_33
,      REFERENCE_34
,      REFERENCE_35
,      REFERENCE_36
,      REFERENCE_37
,      REFERENCE_38
,      REFERENCE_39
,      REFERENCE_40
,      REFERENCE_41
,      REFERENCE_42
,      REFERENCE_43
,      REFERENCE_44
,      REFERENCE_45
,      REFERENCE_46
,      REFERENCE_47
,      REFERENCE_48
,      REFERENCE_49
,      REFERENCE_50
,      REFERENCE_51
,      REFERENCE_52
,      REFERENCE_53
,      REFERENCE_54
,      REFERENCE_55
,      REFERENCE_56
,      REFERENCE_57
,      REFERENCE_58
,      REFERENCE_59
,      REFERENCE_60
,      ORG_ID
,      BALANCE_FLAG
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      REFERENCE_NUM1
,      REFERENCE_NUM2
,      REFERENCE_NUM3
,      REFERENCE_NUM4
,      REFERENCE_NUM5
,      REFERENCE_NUM6
,      REFERENCE_NUM7
,      REFERENCE_NUM8
,      REFERENCE_NUM9
,      REFERENCE_NUM10
,      REFERENCE_DATE1
,      REFERENCE_DATE2
,      REFERENCE_DATE3
,      REFERENCE_DATE4
,      REFERENCE_DATE5
,      REFERENCE_DATE6
,      REFERENCE_DATE7
,      REFERENCE_DATE8
,      REFERENCE_DATE9
,      REFERENCE_DATE10
,      SOURCE_ID
,      SOURCE_TABLE
,      APPLIED_FROM_DOC_ENTITY
,      APPLIED_FROM_DOC_ID
,      APPLIED_TO_DOC_ENTITY
,      APPLIED_TO_DOC_ID
,      TAX_CODE_ID
,      LOCATION_SEGMENT_ID
,      TAX_LINK_ID
,      TAXABLE_ENTERED_DR
,      TAXABLE_ENTERED_CR
,      TAXABLE_ACCOUNTED_DR
,      TAXABLE_ACCOUNTED_CR
,      STAT_AMOUNT
,      LINE_TYPE
,      GL_SL_LINK_ID
,      GL_TRANSFER_LINE_NUM
,      APPLICATION_ID
,      SET_OF_BOOKS_ID
FROM AX.AX_SLE_LINES#;

Dependencies

[top of page]

AX.AX_SLE_LINES# references the following:

SchemaAX
TableAX_SLE_LINES
AX.AX_SLE_LINES# is referenced by following:

SchemaAPPS
SynonymAX_SLE_LINES