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.APFV_AP_INVOICE_DISTRIBUTIONS

Object Details

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

View Type

A Business Intelligence System view

Shows details about particular charges on various types of invoice distribution lines.

[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_CODE	VARCHAR2	(1)
_LA:FINAL_MATCH_STATUS_DESCR	CHAR	(70)
INCOME_TAX_REGION	VARCHAR2	(10)
PRICE_VARIANCE_AMT	NUMBER
DISTRIBUTION_APPROVAL_STATUS	VARCHAR2	(1)
DIST_MATCH_TYPE_CODE	VARCHAR2	(25)
_LA:DIST_MATCH_TYPE_DESCR	CHAR	(65)
_DF	CHAR	(39)
_DF:GLBL	CHAR	(39)
RATE_VARIANCE_ACCOUNT_ID	NUMBER
PO_MATCHED_DIST_QTY_BILLED	NUMBER
TYPE_1099	VARCHAR2	(10)
PO_MATCHED_DIST_UNIT_PRICE	NUMBER
DIST_LINE_ENCUMBRANCE_STATUS	VARCHAR2	(1)
DIST_LINE_TYPE_CODE	VARCHAR2	(25)	Yes
_LA:DIST_LINE_TYPE_DESCR	CHAR	(84)
PRICE_VARIANCE_ACCOUNT_ID	NUMBER
STATISTICAL_QUANTITY	NUMBER
PA_TRANSFER_STATUS_FLAG	VARCHAR2	(1)
_LA:PA_TRANSFER_DESCR	CHAR	(61)
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
EXPENSE_ACCOUNT_ID	NUMBER	(15)	Yes
_KF:ACCOUNT_NUM:EXPENSE:_CO	CHAR	(18)
INVOICE_DIST_AMT	NUMBER
INVOICE_DIST_FUNC_AMT	NUMBER
JUSTIFICATION	VARCHAR2	(240)
INVOICE_ID	NUMBER	(15)	Yes
INVOICE_LINE_NUMBER	NUMBER
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)	Yes
PO_DISTRIBUTION_ID	NUMBER	(15)
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_CODE
,      _LA:FINAL_MATCH_STATUS_DESCR
,      INCOME_TAX_REGION
,      PRICE_VARIANCE_AMT
,      DISTRIBUTION_APPROVAL_STATUS
,      DIST_MATCH_TYPE_CODE
,      _LA:DIST_MATCH_TYPE_DESCR
,      _DF
,      _DF:GLBL
,      RATE_VARIANCE_ACCOUNT_ID
,      PO_MATCHED_DIST_QTY_BILLED
,      TYPE_1099
,      PO_MATCHED_DIST_UNIT_PRICE
,      DIST_LINE_ENCUMBRANCE_STATUS
,      DIST_LINE_TYPE_CODE
,      _LA:DIST_LINE_TYPE_DESCR
,      PRICE_VARIANCE_ACCOUNT_ID
,      STATISTICAL_QUANTITY
,      PA_TRANSFER_STATUS_FLAG
,      _LA:PA_TRANSFER_DESCR
,      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
,      EXPENSE_ACCOUNT_ID
,      _KF:ACCOUNT_NUM:EXPENSE:_CO
,      INVOICE_DIST_AMT
,      INVOICE_DIST_FUNC_AMT
,      JUSTIFICATION
,      INVOICE_ID
,      INVOICE_LINE_NUMBER
,      DISTRIBUTION_LINE_NUMBER
,      PO_DISTRIBUTION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.APFV_AP_INVOICE_DISTRIBUTIONS;

Dependencies

[top of page]

APPS.APFV_AP_INVOICE_DISTRIBUTIONS references the following:

APPS: AP_INVOICE_DISTRIBUTIONS; GL_CODE_COMBINATIONS

APPS.APFV_AP_INVOICE_DISTRIBUTIONS is not referenced by any database object