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

Object Details

Object Name:	PAFV_COST_DISTRIBUTIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PAFV_COST_DISTRIBUTIONS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows information about cost distribution lines.

[View Source]

Columns

Name	Datatype	Length	Mandatory
EXPENDITURE_ITEM_ID	NUMBER	(15)	Yes
LINE_NUMBER	NUMBER	(15)	Yes
AMOUNT	NUMBER		Yes
QUANTITY	NUMBER		Yes
BURDENED_COST	NUMBER
_LA:BILLABLE_FLAG	CHAR	(49)
_LA:REVERSED_FLAG	CHAR	(44)
LINE_NUMBER_REVERSED	NUMBER	(15)
_LA:LINE_TYPE	CHAR	(60)
_LA:TRANSFER_STATUS	CHAR	(59)
PA_DATE	DATE
GL_DATE	DATE
TRANSFERRED_DATE	DATE
TRANSFER_REJECTION_REASON	VARCHAR2	(250)
VENDOR_NAME	VARCHAR2	(240)
INVOICE_BASE_AMOUNT	NUMBER
INVOICE_AMOUNT	NUMBER
VENDOR_ID	NUMBER
AP_INVOICE_ID	NUMBER	(15)
AP_INVOICE_DISTRIBUTION_ID	NUMBER	(15)
AP_INVOICE_LINE_NUMBER	NUMBER	(15)
AP_INVOICE_PAYMENT_ID	NUMBER	(15)
DOCUMENT_TYPE	VARCHAR2	(30)
DOCUMENT_DISTRIBUTION_TYPE	VARCHAR2	(30)
BATCH_NAME	VARCHAR2	(30)
DR_CODE_COMBINATION_ID	NUMBER	(15)
CR_CODE_COMBINATION_ID	NUMBER	(15)
ORG_ID	NUMBER	(15)
ORGANIZATION_NAME	VARCHAR2	(240)
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
DENOM_CURRENCY_CODE	VARCHAR2	(15)
DENOM_RAW_COST	NUMBER
DENOM_BURDENED_COST	NUMBER
ACCT_CURRENCY_CODE	VARCHAR2	(15)
ACCT_RAW_COST	NUMBER
ACCT_BURDENED_COST	NUMBER
ACCT_RATE_TYPE	VARCHAR2	(30)
USER_ACCT_RATE_TYPE	VARCHAR2	(30)
ACCT_RATE_DATE	DATE
ACCT_EXCHANGE_RATE	NUMBER
PROJECT_CURRENCY_CODE	VARCHAR2	(15)
PROJECT_RATE_TYPE	VARCHAR2	(30)
USER_PROJECT_RATE_TYPE	VARCHAR2	(30)
PROJECT_RATE_DATE	DATE
PROJECT_EXCHANGE_RATE	NUMBER
SI_ASSETS_ADDITION_FLAG	VARCHAR2	(1)

Query Text

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


SELECT EXPENDITURE_ITEM_ID
,      LINE_NUMBER
,      AMOUNT
,      QUANTITY
,      BURDENED_COST
,      _LA:BILLABLE_FLAG
,      _LA:REVERSED_FLAG
,      LINE_NUMBER_REVERSED
,      _LA:LINE_TYPE
,      _LA:TRANSFER_STATUS
,      PA_DATE
,      GL_DATE
,      TRANSFERRED_DATE
,      TRANSFER_REJECTION_REASON
,      VENDOR_NAME
,      INVOICE_BASE_AMOUNT
,      INVOICE_AMOUNT
,      VENDOR_ID
,      AP_INVOICE_ID
,      AP_INVOICE_DISTRIBUTION_ID
,      AP_INVOICE_LINE_NUMBER
,      AP_INVOICE_PAYMENT_ID
,      DOCUMENT_TYPE
,      DOCUMENT_DISTRIBUTION_TYPE
,      BATCH_NAME
,      DR_CODE_COMBINATION_ID
,      CR_CODE_COMBINATION_ID
,      ORG_ID
,      ORGANIZATION_NAME
,      CREATION_DATE
,      CREATED_BY
,      DENOM_CURRENCY_CODE
,      DENOM_RAW_COST
,      DENOM_BURDENED_COST
,      ACCT_CURRENCY_CODE
,      ACCT_RAW_COST
,      ACCT_BURDENED_COST
,      ACCT_RATE_TYPE
,      USER_ACCT_RATE_TYPE
,      ACCT_RATE_DATE
,      ACCT_EXCHANGE_RATE
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_TYPE
,      USER_PROJECT_RATE_TYPE
,      PROJECT_RATE_DATE
,      PROJECT_EXCHANGE_RATE
,      SI_ASSETS_ADDITION_FLAG
FROM APPS.PAFV_COST_DISTRIBUTIONS;

Dependencies

[top of page]

APPS.PAFV_COST_DISTRIBUTIONS references the following:

APPS: AP_INVOICE_DISTRIBUTIONS_ALL; HR_ALL_ORGANIZATION_UNITS; HR_ALL_ORGANIZATION_UNITS_TL; PA_CONVERSION_TYPES_V; PA_COST_DISTRIBUTION_LINES_ALL; PA_EXPENDITURE_ITEMS_ALL; PO_VENDORS

APPS.PAFV_COST_DISTRIBUTIONS is not referenced by any database object