eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AX_SLE_LINES_V

Product:	AX - Global Accounting Engine
Description:	Entry lines
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT L.ROWID ROW_ID
, L.JOURNAL_SEQUENCE_ID
, L.SLE_HEADER_ID
, L.SLE_LINE_NUM
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.CREATION_DATE
, L.CREATED_BY
, L.LAST_UPDATE_LOGIN
, L.REQUEST_ID
, L.PROGRAM_APPLICATION_ID
, L.PROGRAM_ID
, L.PROGRAM_UPDATE_DATE
, L.GL_POSTED_FLAG
, L.GL_POSTED_DATE
, L.CODE_COMBINATION_ID
, L.ACCOUNTED_CR
, L.ACCOUNTED_DR
, L.ENTERED_CR
, L.ENTERED_DR
, H.APPLICATION_ID
, L.THIRD_PARTY_ID
, V.VENDOR_NAME THIRD_PARTY_NAME
, L.SUB_ID
, VS.VENDOR_SITE_CODE SUB_NAME
, L.COMMENT_LINE
, L.REFERENCE_1
, L.REFERENCE_2
, L.REFERENCE_3
, L.REFERENCE_4
, L.REFERENCE_5
, L.REFERENCE_6
, L.REFERENCE_7
, L.REFERENCE_8
, L.REFERENCE_9
, L.REFERENCE_10
, L.REFERENCE_11
, L.REFERENCE_12
, L.REFERENCE_13
, L.REFERENCE_14
, L.REFERENCE_15
, L.REFERENCE_16
, L.REFERENCE_17
, L.REFERENCE_18
, L.REFERENCE_19
, L.REFERENCE_20
, L.REFERENCE_21
, L.REFERENCE_22
, L.REFERENCE_23
, L.REFERENCE_24
, L.REFERENCE_25
, L.REFERENCE_26
, L.REFERENCE_27
, L.REFERENCE_28
, L.REFERENCE_29
, L.REFERENCE_30
, L.REFERENCE_31
, L.REFERENCE_32
, L.REFERENCE_33
, L.REFERENCE_34
, L.REFERENCE_35
, L.REFERENCE_36
, L.REFERENCE_37
, L.REFERENCE_38
, L.REFERENCE_39
, L.REFERENCE_40
, L.REFERENCE_41
, L.REFERENCE_42
, L.REFERENCE_43
, L.REFERENCE_44
, L.REFERENCE_45
, L.REFERENCE_46
, L.REFERENCE_47
, L.REFERENCE_48
, L.REFERENCE_49
, L.REFERENCE_50
, L.REFERENCE_51
, L.REFERENCE_52
, L.REFERENCE_53
, L.REFERENCE_54
, L.REFERENCE_55
, L.REFERENCE_56
, L.REFERENCE_57
, L.REFERENCE_58
, L.REFERENCE_59
, L.REFERENCE_60
, L.ORG_ID
, L.BALANCE_FLAG
, L.CURRENCY_CODE
, L.CURRENCY_CONVERSION_TYPE
, L.CURRENCY_CONVERSION_DATE
, L.CURRENCY_CONVERSION_RATE
, L.REFERENCE_NUM1
, L.REFERENCE_NUM2
, L.REFERENCE_NUM3
, L.REFERENCE_NUM4
, L.REFERENCE_NUM5
, L.REFERENCE_NUM6
, L.REFERENCE_NUM7
, L.REFERENCE_NUM8
, L.REFERENCE_NUM9
, L.REFERENCE_NUM10
, L.REFERENCE_DATE1
, L.REFERENCE_DATE2
, L.REFERENCE_DATE3
, L.REFERENCE_DATE4
, L.REFERENCE_DATE5
, L.REFERENCE_DATE6
, L.REFERENCE_DATE7
, L.REFERENCE_DATE8
, L.REFERENCE_DATE9
, L.REFERENCE_DATE10
, L.SOURCE_ID
, L.SOURCE_TABLE
, L.APPLIED_FROM_DOC_ENTITY
, L.APPLIED_FROM_DOC_ID
, L.APPLIED_TO_DOC_ENTITY
, L.APPLIED_TO_DOC_ID
, L.TAX_CODE_ID
, L.LOCATION_SEGMENT_ID
, L.TAX_LINK_ID
, L.TAXABLE_ENTERED_DR
, L.TAXABLE_ENTERED_CR
, L.TAXABLE_ACCOUNTED_DR
, L.TAXABLE_ACCOUNTED_CR
, L.STAT_AMOUNT
, L.LINE_TYPE
, L.GL_SL_LINK_ID
, L.GL_TRANSFER_LINE_NUM
FROM AX_SLE_LINES L
, AX_SLE_HEADERS H
, PO_VENDORS V
, PO_VENDOR_SITES_ALL VS
WHERE L.JOURNAL_SEQUENCE_ID = H.JOURNAL_SEQUENCE_ID
AND L.SLE_HEADER_ID = H.SLE_HEADER_ID
AND H.APPLICATION_ID = 200
AND L.THIRD_PARTY_ID = V.VENDOR_ID (+)
AND L.SUB_ID = VS.VENDOR_SITE_ID (+) UNION SELECT L.ROWID ROW_ID
, L.JOURNAL_SEQUENCE_ID
, L.SLE_HEADER_ID
, L.SLE_LINE_NUM
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.CREATION_DATE
, L.CREATED_BY
, L.LAST_UPDATE_LOGIN
, L.REQUEST_ID
, L.PROGRAM_APPLICATION_ID
, L.PROGRAM_ID
, L.PROGRAM_UPDATE_DATE
, L.GL_POSTED_FLAG
, L.GL_POSTED_DATE
, L.CODE_COMBINATION_ID
, L.ACCOUNTED_CR
, L.ACCOUNTED_DR
, L.ENTERED_CR
, L.ENTERED_DR
, H.APPLICATION_ID
, L.THIRD_PARTY_ID
, C.CUSTOMER_NAME THIRD_PARTY_NAME
, L.SUB_ID
, U.LOCATION SUB_NAME
, L.COMMENT_LINE
, L.REFERENCE_1
, L.REFERENCE_2
, L.REFERENCE_3
, L.REFERENCE_4
, L.REFERENCE_5
, L.REFERENCE_6
, L.REFERENCE_7
, L.REFERENCE_8
, L.REFERENCE_9
, L.REFERENCE_10
, L.REFERENCE_11
, L.REFERENCE_12
, L.REFERENCE_13
, L.REFERENCE_14
, L.REFERENCE_15
, L.REFERENCE_16
, L.REFERENCE_17
, L.REFERENCE_18
, L.REFERENCE_19
, L.REFERENCE_20
, L.REFERENCE_21
, L.REFERENCE_22
, L.REFERENCE_23
, L.REFERENCE_24
, L.REFERENCE_25
, L.REFERENCE_26
, L.REFERENCE_27
, L.REFERENCE_28
, L.REFERENCE_29
, L.REFERENCE_30
, L.REFERENCE_31
, L.REFERENCE_32
, L.REFERENCE_33
, L.REFERENCE_34
, L.REFERENCE_35
, L.REFERENCE_36
, L.REFERENCE_37
, L.REFERENCE_38
, L.REFERENCE_39
, L.REFERENCE_40
, L.REFERENCE_41
, L.REFERENCE_42
, L.REFERENCE_43
, L.REFERENCE_44
, L.REFERENCE_45
, L.REFERENCE_46
, L.REFERENCE_47
, L.REFERENCE_48
, L.REFERENCE_49
, L.REFERENCE_50
, L.REFERENCE_51
, L.REFERENCE_52
, L.REFERENCE_53
, L.REFERENCE_54
, L.REFERENCE_55
, L.REFERENCE_56
, L.REFERENCE_57
, L.REFERENCE_58
, L.REFERENCE_59
, L.REFERENCE_60
, L.ORG_ID
, L.BALANCE_FLAG
, L.CURRENCY_CODE
, L.CURRENCY_CONVERSION_TYPE
, L.CURRENCY_CONVERSION_DATE
, L.CURRENCY_CONVERSION_RATE
, L.REFERENCE_NUM1
, L.REFERENCE_NUM2
, L.REFERENCE_NUM3
, L.REFERENCE_NUM4
, L.REFERENCE_NUM5
, L.REFERENCE_NUM6
, L.REFERENCE_NUM7
, L.REFERENCE_NUM8
, L.REFERENCE_NUM9
, L.REFERENCE_NUM10
, L.REFERENCE_DATE1
, L.REFERENCE_DATE2
, L.REFERENCE_DATE3
, L.REFERENCE_DATE4
, L.REFERENCE_DATE5
, L.REFERENCE_DATE6
, L.REFERENCE_DATE7
, L.REFERENCE_DATE8
, L.REFERENCE_DATE9
, L.REFERENCE_DATE10
, L.SOURCE_ID
, L.SOURCE_TABLE
, L.APPLIED_FROM_DOC_ENTITY
, L.APPLIED_FROM_DOC_ID
, L.APPLIED_TO_DOC_ENTITY
, L.APPLIED_TO_DOC_ID
, L.TAX_CODE_ID
, L.LOCATION_SEGMENT_ID
, L.TAX_LINK_ID
, L.TAXABLE_ENTERED_DR
, L.TAXABLE_ENTERED_CR
, L.TAXABLE_ACCOUNTED_DR
, L.TAXABLE_ACCOUNTED_CR
, L.STAT_AMOUNT
, L.LINE_TYPE
, L.GL_SL_LINK_ID
, L.GL_TRANSFER_LINE_NUM
FROM AX_SLE_LINES L
, AX_SLE_HEADERS H
, RA_CUSTOMERS C
, RA_SITE_USES_ALL U
WHERE L.JOURNAL_SEQUENCE_ID = H.JOURNAL_SEQUENCE_ID
AND L.SLE_HEADER_ID = H.SLE_HEADER_ID
AND H.APPLICATION_ID = 222
AND L.THIRD_PARTY_ID = C.CUSTOMER_ID (+)
AND L.SUB_ID = U.SITE_USE_ID (+) UNION SELECT L.ROWID ROW_ID
, L.JOURNAL_SEQUENCE_ID
, L.SLE_HEADER_ID
, L.SLE_LINE_NUM
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.CREATION_DATE
, L.CREATED_BY
, L.LAST_UPDATE_LOGIN
, L.REQUEST_ID
, L.PROGRAM_APPLICATION_ID
, L.PROGRAM_ID
, L.PROGRAM_UPDATE_DATE
, L.GL_POSTED_FLAG
, L.GL_POSTED_DATE
, L.CODE_COMBINATION_ID
, L.ACCOUNTED_CR
, L.ACCOUNTED_DR
, L.ENTERED_CR
, L.ENTERED_DR
, H.APPLICATION_ID
, L.THIRD_PARTY_ID
, O.ORGANIZATION_NAME THIRD_PARTY_NAME
, L.SUB_ID
, S.SECONDARY_INVENTORY_NAME SUB_NAME
, L.COMMENT_LINE
, L.REFERENCE_1
, L.REFERENCE_2
, L.REFERENCE_3
, L.REFERENCE_4
, L.REFERENCE_5
, L.REFERENCE_6
, L.REFERENCE_7
, L.REFERENCE_8
, L.REFERENCE_9
, L.REFERENCE_10
, L.REFERENCE_11
, L.REFERENCE_12
, L.REFERENCE_13
, L.REFERENCE_14
, L.REFERENCE_15
, L.REFERENCE_16
, L.REFERENCE_17
, L.REFERENCE_18
, L.REFERENCE_19
, L.REFERENCE_20
, L.REFERENCE_21
, L.REFERENCE_22
, L.REFERENCE_23
, L.REFERENCE_24
, L.REFERENCE_25
, L.REFERENCE_26
, L.REFERENCE_27
, L.REFERENCE_28
, L.REFERENCE_29
, L.REFERENCE_30
, L.REFERENCE_31
, L.REFERENCE_32
, L.REFERENCE_33
, L.REFERENCE_34
, L.REFERENCE_35
, L.REFERENCE_36
, L.REFERENCE_37
, L.REFERENCE_38
, L.REFERENCE_39
, L.REFERENCE_40
, L.REFERENCE_41
, L.REFERENCE_42
, L.REFERENCE_43
, L.REFERENCE_44
, L.REFERENCE_45
, L.REFERENCE_46
, L.REFERENCE_47
, L.REFERENCE_48
, L.REFERENCE_49
, L.REFERENCE_50
, L.REFERENCE_51
, L.REFERENCE_52
, L.REFERENCE_53
, L.REFERENCE_54
, L.REFERENCE_55
, L.REFERENCE_56
, L.REFERENCE_57
, L.REFERENCE_58
, L.REFERENCE_59
, L.REFERENCE_60
, L.ORG_ID
, L.BALANCE_FLAG
, L.CURRENCY_CODE
, L.CURRENCY_CONVERSION_TYPE
, L.CURRENCY_CONVERSION_DATE
, L.CURRENCY_CONVERSION_RATE
, L.REFERENCE_NUM1
, L.REFERENCE_NUM2
, L.REFERENCE_NUM3
, L.REFERENCE_NUM4
, L.REFERENCE_NUM5
, L.REFERENCE_NUM6
, L.REFERENCE_NUM7
, L.REFERENCE_NUM8
, L.REFERENCE_NUM9
, L.REFERENCE_NUM10
, L.REFERENCE_DATE1
, L.REFERENCE_DATE2
, L.REFERENCE_DATE3
, L.REFERENCE_DATE4
, L.REFERENCE_DATE5
, L.REFERENCE_DATE6
, L.REFERENCE_DATE7
, L.REFERENCE_DATE8
, L.REFERENCE_DATE9
, L.REFERENCE_DATE10
, L.SOURCE_ID
, L.SOURCE_TABLE
, L.APPLIED_FROM_DOC_ENTITY
, L.APPLIED_FROM_DOC_ID
, L.APPLIED_TO_DOC_ENTITY
, L.APPLIED_TO_DOC_ID
, L.TAX_CODE_ID
, L.LOCATION_SEGMENT_ID
, L.TAX_LINK_ID
, L.TAXABLE_ENTERED_DR
, L.TAXABLE_ENTERED_CR
, L.TAXABLE_ACCOUNTED_DR
, L.TAXABLE_ACCOUNTED_CR
, L.STAT_AMOUNT
, L.LINE_TYPE
, L.GL_SL_LINK_ID
, L.GL_TRANSFER_LINE_NUM
FROM AX_SLE_LINES L
, AX_SLE_HEADERS H
, ORG_ORGANIZATION_DEFINITIONS O
, AX_SECONDARY_INVENTORY S
WHERE L.JOURNAL_SEQUENCE_ID = H.JOURNAL_SEQUENCE_ID
AND L.SLE_HEADER_ID = H.SLE_HEADER_ID
AND H.APPLICATION_ID = 401
AND L.THIRD_PARTY_ID = O.ORGANIZATION_ID (+)
AND L.SUB_ID = S.SECONDARY_INVENTORY_ID (+)

Columns

Name
ROW_ID
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
APPLICATION_ID
THIRD_PARTY_ID
THIRD_PARTY_NAME
SUB_ID
SUB_NAME
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