VIEW: AP.AP_AE_LINES_ALL#

Source

View Text - Preformatted

select AE_LINE_ID AE_LINE_ID, AE_HEADER_ID AE_HEADER_ID, AE_LINE_NUMBER AE_LINE_NUMBER, AE_LINE_TYPE_CODE AE_LINE_TYPE_CODE, CODE_COMBINATION_ID CODE_COMBINATION_ID, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, ENTERED_DR ENTERED_DR, ENTERED_CR ENTERED_CR, ACCOUNTED_DR ACCOUNTED_DR, ACCOUNTED_CR ACCOUNTED_CR, SOURCE_TABLE SOURCE_TABLE, SOURCE_ID SOURCE_ID, ACCOUNT_OVERLAY_SOURCE_ID ACCOUNT_OVERLAY_SOURCE_ID, GL_SL_LINK_ID GL_SL_LINK_ID, DESCRIPTION DESCRIPTION, ACCOUNTING_ERROR_CODE ACCOUNTING_ERROR_CODE, GL_TRANSFER_ERROR_CODE GL_TRANSFER_ERROR_CODE, THIRD_PARTY_ID THIRD_PARTY_ID, THIRD_PARTY_SUB_ID THIRD_PARTY_SUB_ID, STAT_AMOUNT STAT_AMOUNT, SUBLEDGER_DOC_SEQUENCE_ID SUBLEDGER_DOC_SEQUENCE_ID, SUBLEDGER_DOC_SEQUENCE_VALUE SUBLEDGER_DOC_SEQUENCE_VALUE, ORG_ID ORG_ID, CREATION_DATE CREATION_DATE, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, REQUEST_ID REQUEST_ID, REFERENCE1 REFERENCE1, REFERENCE2 REFERENCE2, REFERENCE3 REFERENCE3, REFERENCE4 REFERENCE4, REFERENCE5 REFERENCE5, REFERENCE6 REFERENCE6, REFERENCE7 REFERENCE7, REFERENCE8 REFERENCE8, REFERENCE9 REFERENCE9, REFERENCE10 REFERENCE10, APPLIED_FROM_TRX_HDR_TABLE APPLIED_FROM_TRX_HDR_TABLE, APPLIED_FROM_TRX_HDR_ID APPLIED_FROM_TRX_HDR_ID, APPLIED_TO_TRX_HDR_TABLE APPLIED_TO_TRX_HDR_TABLE, APPLIED_TO_TRX_HDR_ID APPLIED_TO_TRX_HDR_ID, TAX_CODE_ID TAX_CODE_ID, TAXABLE_ENTERED_DR TAXABLE_ENTERED_DR, TAXABLE_ENTERED_CR TAXABLE_ENTERED_CR, TAXABLE_ACCOUNTED_DR TAXABLE_ACCOUNTED_DR, TAXABLE_ACCOUNTED_CR TAXABLE_ACCOUNTED_CR, TAX_LINK_ID TAX_LINK_ID from "AP"."AP_AE_LINES_ALL"

View Text - HTML Formatted

SELECT AE_LINE_ID AE_LINE_ID
, AE_HEADER_ID AE_HEADER_ID
, AE_LINE_NUMBER AE_LINE_NUMBER
, AE_LINE_TYPE_CODE AE_LINE_TYPE_CODE
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, ENTERED_DR ENTERED_DR
, ENTERED_CR ENTERED_CR
, ACCOUNTED_DR ACCOUNTED_DR
, ACCOUNTED_CR ACCOUNTED_CR
, SOURCE_TABLE SOURCE_TABLE
, SOURCE_ID SOURCE_ID
, ACCOUNT_OVERLAY_SOURCE_ID ACCOUNT_OVERLAY_SOURCE_ID
, GL_SL_LINK_ID GL_SL_LINK_ID
, DESCRIPTION DESCRIPTION
, ACCOUNTING_ERROR_CODE ACCOUNTING_ERROR_CODE
, GL_TRANSFER_ERROR_CODE GL_TRANSFER_ERROR_CODE
, THIRD_PARTY_ID THIRD_PARTY_ID
, THIRD_PARTY_SUB_ID THIRD_PARTY_SUB_ID
, STAT_AMOUNT STAT_AMOUNT
, SUBLEDGER_DOC_SEQUENCE_ID SUBLEDGER_DOC_SEQUENCE_ID
, SUBLEDGER_DOC_SEQUENCE_VALUE SUBLEDGER_DOC_SEQUENCE_VALUE
, ORG_ID ORG_ID
, CREATION_DATE CREATION_DATE
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, REQUEST_ID REQUEST_ID
, REFERENCE1 REFERENCE1
, REFERENCE2 REFERENCE2
, REFERENCE3 REFERENCE3
, REFERENCE4 REFERENCE4
, REFERENCE5 REFERENCE5
, REFERENCE6 REFERENCE6
, REFERENCE7 REFERENCE7
, REFERENCE8 REFERENCE8
, REFERENCE9 REFERENCE9
, REFERENCE10 REFERENCE10
, APPLIED_FROM_TRX_HDR_TABLE APPLIED_FROM_TRX_HDR_TABLE
, APPLIED_FROM_TRX_HDR_ID APPLIED_FROM_TRX_HDR_ID
, APPLIED_TO_TRX_HDR_TABLE APPLIED_TO_TRX_HDR_TABLE
, APPLIED_TO_TRX_HDR_ID APPLIED_TO_TRX_HDR_ID
, TAX_CODE_ID TAX_CODE_ID
, TAXABLE_ENTERED_DR TAXABLE_ENTERED_DR
, TAXABLE_ENTERED_CR TAXABLE_ENTERED_CR
, TAXABLE_ACCOUNTED_DR TAXABLE_ACCOUNTED_DR
, TAXABLE_ACCOUNTED_CR TAXABLE_ACCOUNTED_CR
, TAX_LINK_ID TAX_LINK_ID
FROM "AP"."AP_AE_LINES_ALL"