VIEW: BOM.CST_ENCUMBRANCE_LINES#

Source

View Text - Preformatted

select ENCUMBRANCE_LINE_ID ENCUMBRANCE_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, RATE_OR_AMOUNT RATE_OR_AMOUNT, BASIS_TYPE BASIS_TYPE, RESOURCE_ID RESOURCE_ID, COST_ELEMENT_ID COST_ELEMENT_ID, ACTIVITY_ID ACTIVITY_ID, REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID, OVERHEAD_BASIS_FACTOR OVERHEAD_BASIS_FACTOR, BASIS_RESOURCE_ID BASIS_RESOURCE_ID, GL_SL_LINK_ID GL_SL_LINK_ID, DESCRIPTION DESCRIPTION, ACCOUNTING_ERROR_CODE ACCOUNTING_ERROR_CODE, STAT_AMOUNT STAT_AMOUNT, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, SUBLEDGER_DOC_SEQUENCE_ID SUBLEDGER_DOC_SEQUENCE_ID, SUBLEDGER_DOC_SEQUENCE_VALUE SUBLEDGER_DOC_SEQUENCE_VALUE, GL_TRANSFER_ERROR_CODE GL_TRANSFER_ERROR_CODE, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, REFERENCE1 REFERENCE1, REFERENCE2 REFERENCE2, REFERENCE3 REFERENCE3, REFERENCE4 REFERENCE4, REFERENCE5 REFERENCE5, REFERENCE6 REFERENCE6, REFERENCE7 REFERENCE7, REFERENCE8 REFERENCE8, REFERENCE9 REFERENCE9, REFERENCE10 REFERENCE10, CREATION_DATE CREATION_DATE, 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, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID from "BOM"."CST_ENCUMBRANCE_LINES"

View Text - HTML Formatted

SELECT ENCUMBRANCE_LINE_ID ENCUMBRANCE_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
, RATE_OR_AMOUNT RATE_OR_AMOUNT
, BASIS_TYPE BASIS_TYPE
, RESOURCE_ID RESOURCE_ID
, COST_ELEMENT_ID COST_ELEMENT_ID
, ACTIVITY_ID ACTIVITY_ID
, REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID
, OVERHEAD_BASIS_FACTOR OVERHEAD_BASIS_FACTOR
, BASIS_RESOURCE_ID BASIS_RESOURCE_ID
, GL_SL_LINK_ID GL_SL_LINK_ID
, DESCRIPTION DESCRIPTION
, ACCOUNTING_ERROR_CODE ACCOUNTING_ERROR_CODE
, STAT_AMOUNT STAT_AMOUNT
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, SUBLEDGER_DOC_SEQUENCE_ID SUBLEDGER_DOC_SEQUENCE_ID
, SUBLEDGER_DOC_SEQUENCE_VALUE SUBLEDGER_DOC_SEQUENCE_VALUE
, GL_TRANSFER_ERROR_CODE GL_TRANSFER_ERROR_CODE
, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, REFERENCE1 REFERENCE1
, REFERENCE2 REFERENCE2
, REFERENCE3 REFERENCE3
, REFERENCE4 REFERENCE4
, REFERENCE5 REFERENCE5
, REFERENCE6 REFERENCE6
, REFERENCE7 REFERENCE7
, REFERENCE8 REFERENCE8
, REFERENCE9 REFERENCE9
, REFERENCE10 REFERENCE10
, CREATION_DATE CREATION_DATE
, 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
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
FROM "BOM"."CST_ENCUMBRANCE_LINES"