VIEW: APPS.AP_ENCUMBRANCE_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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