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

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

PA_PROJ_AP_INV_DISTRIBUTIONS is a view of project-related Oracle
Payables invoice distributions not yet transferred to Oracle Projects.
.
.
These invoice distributions include those matched to purchase order
distributions, and those that are on approved invoices.
.
.
The invoice distributions may not be in Oracle Projects
because they are not yet posted, which is required before the
invoice distribution can be transferred to Oracle Projects,
or the Transfer Supplier Invoices program has not been run for the
distributions.
.
.
You can use this view to report the details of the Pending Invoices
amount of the project committed costs in the PA_PROJ_COMMITMENT_STATUS
view. Pending invoice costs are considered part of project committed
costs since the costs are not yet reflected in Oracle Projects actual
project costs.
.
.

[View Source]

Columns

Name	Datatype	Length	Comments
INVOICE_NUMBER	VARCHAR2	(50)	Invoice number
VENDOR_NAME	VARCHAR2	(240)	Supplier name
INVOICE_DATE	DATE		Invoice date
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)	Distribution line number
DESCRIPTION	VARCHAR2	(240)	Description of the invoice distribution
GL_DATE	DATE		The GL date on which the costs are posted, which is entered during invoice entry
POSTED_FLAG	VARCHAR2	(1)	Flag that indicates if invoice distribution has been posted to Oracle General Ledger
APPROVED_FLAG	VARCHAR2	(1)	Indicates if the invoice is approved
QUANTITY	NUMBER		Quantity of units as defined by the expenditure type, which is entered for the project-related distribution
DENOM_CURRENCY_CODE	VARCHAR2	(15)	Transaction Currency Code of the Invoice
DENOM_AMOUNT	NUMBER		Invoice amount entered in transaction currency
ACCT_CURRENCY_CODE	VARCHAR2	(15)	Functional currency code.
AMOUNT	NUMBER		Invoice amount in functional curency for project-related invoice distribution
ACCT_RATE_DATE	DATE		Conversion date used to convert invoice amount from transaction currency to functional currency .
ACCT_RATE_TYPE	VARCHAR2	(30)	Conversion type used to convert invoice amount from transaction currency to functional currency . e.g. Spot,Corporate
ACCT_EXCHANGE_RATE	NUMBER		Conversion rate used to convert invoice amount from transaction currency to functional currency .
RECEIPT_CURRENCY_CODE	VARCHAR2	(15)	Currency code of receipt. Used for Expense Reports
RECEIPT_CURRENCY_AMOUNT	NUMBER		Amount in receipt currency. Used for Expense Reports
RECEIPT_EXCHANGE_RATE	NUMBER		Exchange rate for currency of receipt. Used for Expense Reports
PROJECT_NUMBER	VARCHAR2	(25)	Project number incurring the charge
PROJECT_NAME	VARCHAR2	(30)	Name of the project incurring the charge
TASK_NUMBER	VARCHAR2	(25)	Number of the lowest level task incurring the charge
TASK_NAME	VARCHAR2	(20)	Name of the lowest level task incurring the charge
EXPENDITURE_TYPE	VARCHAR2	(30)	Expenditure type charged
EXPENDITURE_CATEGORY	VARCHAR2	(30)	The expenditure category of the expenditure type
REVENUE_CATEGORY	VARCHAR2	(30)	The revenue category of the expenditure type
EXPENDITURE_ITEM_DATE	DATE		The expenditure item date on which you incur the invoice costs
EXPENDITURE_ORGANIZATION	VARCHAR2	(240)	The expenditure organization incurring the charge
INVOICE_ID	NUMBER	(15)	The identifier of the invoice
VENDOR_ID	NUMBER	(15)	The identifier of the vendor
PROJECT_ID	NUMBER	(15)	The identifier of the project
TASK_ID	NUMBER	(15)	The identifier of the lowest level task
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)	The identifier of the expenditure organization
RESOURCE_CLASS	CHAR	(18)	Resource Class
INVOICE_LINE_NUMBER	NUMBER		Invoice Line Number. Identifies the invoice line number
INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Unique identifier for the invoice distributions
CASH_BASIS_ACCT_IMPL	VARCHAR2	(1)	Cash Basis Accounting implementation flag
AWARD_SET_ID	NUMBER	(15)	Award Distribution Identifer for Grants Accounting
CBS_ELEMENT_ID	NUMBER		This is the unique identifier of the cost code element.

Query Text

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


SELECT INVOICE_NUMBER
,      VENDOR_NAME
,      INVOICE_DATE
,      DISTRIBUTION_LINE_NUMBER
,      DESCRIPTION
,      GL_DATE
,      POSTED_FLAG
,      APPROVED_FLAG
,      QUANTITY
,      DENOM_CURRENCY_CODE
,      DENOM_AMOUNT
,      ACCT_CURRENCY_CODE
,      AMOUNT
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_CURRENCY_AMOUNT
,      RECEIPT_EXCHANGE_RATE
,      PROJECT_NUMBER
,      PROJECT_NAME
,      TASK_NUMBER
,      TASK_NAME
,      EXPENDITURE_TYPE
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_ORGANIZATION
,      INVOICE_ID
,      VENDOR_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_ORGANIZATION_ID
,      RESOURCE_CLASS
,      INVOICE_LINE_NUMBER
,      INVOICE_DISTRIBUTION_ID
,      CASH_BASIS_ACCT_IMPL
,      AWARD_SET_ID
,      CBS_ELEMENT_ID
FROM APPS.PA_PROJ_AP_INV_DISTRIBUTIONS;

Dependencies

[top of page]

APPS.PA_PROJ_AP_INV_DISTRIBUTIONS references the following:

APPS: AP_INVOICES_ALL; AP_INVOICES_PKG - show dependent code; AP_INVOICE_DISTRIBUTIONS_ALL; AP_SELF_ASSESSED_TAX_DIST_ALL; FND_PROFILE - show dependent code; GL_LEDGERS; HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code; PA_CMT_UTILS - show dependent code; PA_EXPENDITURE_TYPES; PA_EXPEND_TYP_SYS_LINKS; PA_PROJECTS_ALL; PA_TASKS; PA_TASKS_EXPEND_V; PA_TASK_UTILS - show dependent code; PA_UTILS4 - show dependent code; PO_DISTRIBUTIONS_ALL; PO_VENDORS

APPS.PA_PROJ_AP_INV_DISTRIBUTIONS is referenced by following:

APPS: GMS_COMMITMENTS_OVERRIDE_V; GMS_PA_API3 - show dependent code; PA_CHECK_COMMITMENTS - show dependent code; PA_COMMITMENT_TXNS_V; PA_PROJ_COMMITMENT_BASE_VIEW