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_DIST_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Comments
INVOICE_NUMBER	VARCHAR2	(50)	Invoice number
VENDOR_NAME	VARCHAR2	(240)	Supplier name
INVOICE_DATE	DATE		Invoice date
INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Invoice Distribution ID
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)
RECEIPT_CURRENCY_AMOUNT	NUMBER
RECEIPT_EXCHANGE_RATE	NUMBER
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
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)

Query Text

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


SELECT INVOICE_NUMBER
,      VENDOR_NAME
,      INVOICE_DATE
,      INVOICE_DISTRIBUTION_ID
,      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
,      INVOICE_ID
,      VENDOR_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_ORGANIZATION_ID
,      RESOURCE_CLASS
FROM APPS.PA_PROJ_AP_INV_DIST_V;

Dependencies

[top of page]

APPS.PA_PROJ_AP_INV_DIST_V references the following:

APPS: AP_INVOICES_ALL; AP_INVOICES_PKG - show dependent code; AP_INVOICE_DISTRIBUTIONS_ALL; AP_SELF_ASSESSED_TAX_DIST_ALL; GL_SETS_OF_BOOKS; PA_CMT_UTILS - show dependent code; PA_EXPENDITURE_TYPES; PA_EXPEND_TYP_SYS_LINKS; PA_PROJECTS; PA_TASKS; PO_DISTRIBUTIONS_ALL; PO_VENDORS

APPS.PA_PROJ_AP_INV_DIST_V is referenced by following:

APPS: PA_COMMITMENTS_V