eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.APBV_AP_INVOICE_DISTRIBUTIONS

Object Details

Object Name:	APBV_AP_INVOICE_DISTRIBUTIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLAP.APBV_AP_INVOICE_DISTRIBUTIONS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows details about particular charges on an invoice, and includes information about whether an amount is for an item, tax, freight, or miscellaneous charge.

[View Source]

Columns

Name	Datatype	Length	Mandatory
PRICE_VARIANCE_FUNCTIONAL_AMT	NUMBER
INVOICE_DIST_DESCRIPTION	VARCHAR2	(240)
CRNCY_EXCHANGE_RATE_VARIANCE	NUMBER
FINAL_MATCHING_STATUS	VARCHAR2	(1)
INCOME_TAX_REGION	VARCHAR2	(10)
PRICE_VARIANCE_AMT	NUMBER
DISTRIBUTION_APPROVAL_STATUS	VARCHAR2	(1)
PO_MATCHED_DIST_QTY_BILLED	NUMBER
TYPE_1099	VARCHAR2	(10)
PO_MATCHED_DIST_UNIT_PRICE	NUMBER
DIST_LINE_ENCUMBRANCE_STATUS	VARCHAR2	(1)
STATISTICAL_QUANTITY	NUMBER
PA_TRANSFER_STATUS_FLAG	VARCHAR2	(1)
POSTED_TO_GL_AMOUNT	NUMBER
POSTED_TO_GL_FUNCTIONAL_AMOUNT	NUMBER
ACCOUNTING_DATE	DATE		Yes
PREPAY_AMOUNT_REMAINING	NUMBER
QUANTITY_VARIANCE	NUMBER
FUNCTIONAL_QTY_VARIANCE_AMT	NUMBER
AWT_FLAG	VARCHAR2	(1)
AWT_GROSS_AMOUNT	NUMBER
AMOUNT_INCLUDES_TAX_FLAG	CHAR	(8)
POSTED_FLAG	VARCHAR2	(1)
TRANSFERRED_TO_ASSETS_FLAG	VARCHAR2	(1)	Yes
ASSET_RELATED_FLAG	VARCHAR2	(1)	Yes
_KF:ACT_NUM:EXPENSE_ACT:_CO	CHAR	(18)
INVOICE_DIST_AMT	NUMBER
INVOICE_DIST_FUNC_AMT	NUMBER
INVOICE_ID	NUMBER	(15)	Yes
INVOICE_LINE_NUMBER	NUMBER
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)	Yes
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.APBV_AP_INVOICE_DISTRIBUTIONS;

Dependencies

[top of page]

APPS.APBV_AP_INVOICE_DISTRIBUTIONS references the following:

APPS: AP_INVOICE_DISTRIBUTIONS; GL_CODE_COMBINATIONS

APPS.APBV_AP_INVOICE_DISTRIBUTIONS is not referenced by any database object