View: CST_PAC_AE_LINES_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_PAC_AE_LINES_V

View Text

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

Columns