FND Design Data [Home] [Help]

View: APBV_AP_INVOICE_DISTRIBUTIONS

Product: AP - Payables
Description: Business view
Implementation/DBA Data: ViewAPPS.APBV_AP_INVOICE_DISTRIBUTIONS
View Text

SELECT TO_NUMBER(NULL)
, INV.DESCRIPTION
, TO_NUMBER(NULL)
, INV.FINAL_MATCH_FLAG
, INV.INCOME_TAX_REGION
, TO_NUMBER(NULL)
, INV.MATCH_STATUS_FLAG
, INV.QUANTITY_INVOICED
, INV.TYPE_1099
, INV.UNIT_PRICE
, INV.ENCUMBERED_FLAG
, INV.STAT_AMOUNT
, INV.PA_ADDITION_FLAG
, INV.POSTED_AMOUNT
, INV.POSTED_BASE_AMOUNT
, INV.ACCOUNTING_DATE
, INV.PREPAY_AMOUNT_REMAINING
, INV.QUANTITY_VARIANCE
, INV.BASE_QUANTITY_VARIANCE
, INV.AWT_FLAG
, INV.AWT_GROSS_AMOUNT
, 'OBSOLETE'
, INV.POSTED_FLAG
, INV.ASSETS_ADDITION_FLAG
, INV.ASSETS_TRACKING_FLAG
, '_KF:SQLGL:GL#:GCC3'
, INV.AMOUNT
, INV.BASE_AMOUNT
, INV.INVOICE_ID
, INV.INVOICE_LINE_NUMBER
, INV.DISTRIBUTION_LINE_NUMBER
, INV.CREATION_DATE
, INV.CREATED_BY
, INV.LAST_UPDATE_DATE
, INV.LAST_UPDATED_BY
FROM AP_INVOICE_DISTRIBUTIONS INV
, GL_CODE_COMBINATIONS GCC3
WHERE INV. DIST_CODE_COMBINATION_ID = GCC3.CODE_COMBINATION_ID WITH READ ONLY

Columns

Name
PRICE_VARIANCE_FUNCTIONAL_AMT
INVOICE_DIST_DESCRIPTION
CRNCY_EXCHANGE_RATE_VARIANCE
FINAL_MATCHING_STATUS
INCOME_TAX_REGION
PRICE_VARIANCE_AMT
DISTRIBUTION_APPROVAL_STATUS
PO_MATCHED_DIST_QTY_BILLED
TYPE_1099
PO_MATCHED_DIST_UNIT_PRICE
DIST_LINE_ENCUMBRANCE_STATUS
STATISTICAL_QUANTITY
PA_TRANSFER_STATUS_FLAG
POSTED_TO_GL_AMOUNT
POSTED_TO_GL_FUNCTIONAL_AMOUNT
ACCOUNTING_DATE
PREPAY_AMOUNT_REMAINING
QUANTITY_VARIANCE
FUNCTIONAL_QTY_VARIANCE_AMT
AWT_FLAG
AWT_GROSS_AMOUNT
AMOUNT_INCLUDES_TAX_FLAG
POSTED_FLAG
TRANSFERRED_TO_ASSETS_FLAG
ASSET_RELATED_FLAG
"_KF:ACT_NUM:EXPENSE_ACT:_CO"
INVOICE_DIST_AMT
INVOICE_DIST_FUNC_AMT
INVOICE_ID
INVOICE_LINE_NUMBER
DISTRIBUTION_LINE_NUMBER
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY