VIEW: APPS.CST_PAC_AE_LINES_V

Source

View Text - Preformatted

SELECT AE_LINE_ID , AE_HEADER_ID , AE_LINE_NUMBER , AE_LINE_TYPE_CODE , CODE_COMBINATION_ID , CURRENCY_CODE , CURRENCY_CONVERSION_TYPE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , ENTERED_DR , ENTERED_CR , ACCOUNTED_DR , ACCOUNTED_CR , SOURCE_TABLE , SOURCE_ID , RATE_OR_AMOUNT , BASIS_TYPE , RESOURCE_ID , COST_ELEMENT_ID , ACTIVITY_ID , REPETITIVE_SCHEDULE_ID , OVERHEAD_BASIS_FACTOR , BASIS_RESOURCE_ID , GL_SL_LINK_ID , DESCRIPTION , ACCOUNTING_ERROR_CODE , STAT_AMOUNT , USSGL_TRANSACTION_CODE , SUBLEDGER_DOC_SEQUENCE_ID , SUBLEDGER_DOC_SEQUENCE_VALUE , GL_TRANSFER_ERROR_CODE , REFERENCE1 , REFERENCE2 , REFERENCE3 , REFERENCE4 , REFERENCE5 , REFERENCE6 , REFERENCE7 , REFERENCE8 , REFERENCE9 , REFERENCE10 , CREATION_DATE , CREATED_BY , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN , PROGRAM_UPDATE_DATE , PROGRAM_APPLICATION_ID , PROGRAM_ID , REQUEST_ID , PO_DISTRIBUTION_ID , 'A' FROM cst_ae_lines UNION ALL SELECT ENCUMBRANCE_LINE_ID , AE_HEADER_ID , AE_LINE_NUMBER , AE_LINE_TYPE_CODE , CODE_COMBINATION_ID , CURRENCY_CODE , CURRENCY_CONVERSION_TYPE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , ENTERED_DR , ENTERED_CR , ACCOUNTED_DR , ACCOUNTED_CR , SOURCE_TABLE , SOURCE_ID , RATE_OR_AMOUNT , BASIS_TYPE , RESOURCE_ID , COST_ELEMENT_ID , ACTIVITY_ID , REPETITIVE_SCHEDULE_ID , OVERHEAD_BASIS_FACTOR , BASIS_RESOURCE_ID , GL_SL_LINK_ID , DESCRIPTION , ACCOUNTING_ERROR_CODE , STAT_AMOUNT , USSGL_TRANSACTION_CODE , SUBLEDGER_DOC_SEQUENCE_ID , SUBLEDGER_DOC_SEQUENCE_VALUE , GL_TRANSFER_ERROR_CODE , REFERENCE1 , REFERENCE2 , REFERENCE3 , REFERENCE4 , REFERENCE5 , REFERENCE6 , REFERENCE7 , REFERENCE8 , REFERENCE9 , REFERENCE10 , CREATION_DATE , CREATED_BY , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN , PROGRAM_UPDATE_DATE , PROGRAM_APPLICATION_ID , PROGRAM_ID , REQUEST_ID , PO_DISTRIBUTION_ID , 'E' FROM cst_encumbrance_lines

View Text - HTML Formatted

SELECT AE_LINE_ID
, AE_HEADER_ID
, AE_LINE_NUMBER
, AE_LINE_TYPE_CODE
, CODE_COMBINATION_ID
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, ENTERED_DR
, ENTERED_CR
, ACCOUNTED_DR
, ACCOUNTED_CR
, SOURCE_TABLE
, SOURCE_ID
, RATE_OR_AMOUNT
, BASIS_TYPE
, RESOURCE_ID
, COST_ELEMENT_ID
, ACTIVITY_ID
, REPETITIVE_SCHEDULE_ID
, OVERHEAD_BASIS_FACTOR
, BASIS_RESOURCE_ID
, GL_SL_LINK_ID
, DESCRIPTION
, ACCOUNTING_ERROR_CODE
, STAT_AMOUNT
, USSGL_TRANSACTION_CODE
, SUBLEDGER_DOC_SEQUENCE_ID
, SUBLEDGER_DOC_SEQUENCE_VALUE
, GL_TRANSFER_ERROR_CODE
, REFERENCE1
, REFERENCE2
, REFERENCE3
, REFERENCE4
, REFERENCE5
, REFERENCE6
, REFERENCE7
, REFERENCE8
, REFERENCE9
, REFERENCE10
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, REQUEST_ID
, PO_DISTRIBUTION_ID
, 'A'
FROM CST_AE_LINES UNION ALL SELECT ENCUMBRANCE_LINE_ID
, AE_HEADER_ID
, AE_LINE_NUMBER
, AE_LINE_TYPE_CODE
, CODE_COMBINATION_ID
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, ENTERED_DR
, ENTERED_CR
, ACCOUNTED_DR
, ACCOUNTED_CR
, SOURCE_TABLE
, SOURCE_ID
, RATE_OR_AMOUNT
, BASIS_TYPE
, RESOURCE_ID
, COST_ELEMENT_ID
, ACTIVITY_ID
, REPETITIVE_SCHEDULE_ID
, OVERHEAD_BASIS_FACTOR
, BASIS_RESOURCE_ID
, GL_SL_LINK_ID
, DESCRIPTION
, ACCOUNTING_ERROR_CODE
, STAT_AMOUNT
, USSGL_TRANSACTION_CODE
, SUBLEDGER_DOC_SEQUENCE_ID
, SUBLEDGER_DOC_SEQUENCE_VALUE
, GL_TRANSFER_ERROR_CODE
, REFERENCE1
, REFERENCE2
, REFERENCE3
, REFERENCE4
, REFERENCE5
, REFERENCE6
, REFERENCE7
, REFERENCE8
, REFERENCE9
, REFERENCE10
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, REQUEST_ID
, PO_DISTRIBUTION_ID
, 'E'
FROM CST_ENCUMBRANCE_LINES