View: AP_ENCUMBRANCE_LINES_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.AP_ENCUMBRANCE_LINES_V

View Text

SELECT AELA.ROWID ROW_ID
, AELA.ENCUMBRANCE_LINE_ID ENCUMBRANCE_LINE_ID
, GET.ENCUMBRANCE_TYPE ENCUMBRANCE_TYPE
, ALC.DISPLAYED_FIELD LINE_TYPE
, AELA.CODE_COMBINATION_ID CODE_COMBINATION_ID
, AELA.ACCOUNTED_DR DEBIT_AMOUNT
, AELA.ACCOUNTED_CR CREDIT_AMOUNT
, AELA.PERIOD_NAME PERIOD
, AELA.ACCOUNTING_DATE ACCOUNTING_DATE
, AELA.REVERSAL_FLAG REVERSAL
, AI.INVOICE_ID INVOICE_ID
, AI.INVOICE_NUM INVOICE_NUM
, AELA.INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, AID.DISTRIBUTION_LINE_NUMBER DIST_LINE_NUM
, AID.DESCRIPTION DIST_DESC
FROM AP_ENCUMBRANCE_LINES AELA
, AP_INVOICE_DISTRIBUTIONS AID
, AP_INVOICES AI
, GL_ENCUMBRANCE_TYPES GET
, AP_LOOKUP_CODES ALC
WHERE AELA.ENCUMBRANCE_TYPE_ID = GET.ENCUMBRANCE_TYPE_ID
AND AELA.ENCUMBRANCE_LINE_TYPE = ALC.LOOKUP_CODE
AND ALC.LOOKUP_TYPE = 'AE LINE TYPE'
AND AELA.INVOICE_DISTRIBUTION_ID = AID.INVOICE_DISTRIBUTION_ID
AND AID.INVOICE_ID = AI.INVOICE_ID

Columns