[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| 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 |
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.
.
.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INVOICE_NUMBER | VARCHAR2 | (50) | Yes | Invoice number |
| VENDOR_NAME | VARCHAR2 | (240) | Supplier name | |
| INVOICE_DATE | DATE | Invoice date | ||
| DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | Yes | Distribution line number |
| DESCRIPTION | VARCHAR2 | (240) | Description of the invoice distribution | |
| GL_DATE | DATE | Yes | 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) | Yes | Transaction Currency Code of the Invoice |
| DENOM_AMOUNT | NUMBER | Invoice amount entered in transaction currency | ||
| ACCT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | 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) | Yes | Project number incurring the charge |
| PROJECT_NAME | VARCHAR2 | (30) | Yes | Name of the project incurring the charge |
| TASK_NUMBER | VARCHAR2 | (25) | Yes | Number of the lowest level task incurring the charge |
| TASK_NAME | VARCHAR2 | (20) | Yes | Name of the lowest level task incurring the charge |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Expenditure type charged | |
| EXPENDITURE_CATEGORY | VARCHAR2 | (30) | Yes | The expenditure category of the expenditure type |
| REVENUE_CATEGORY | VARCHAR2 | (30) | Yes | 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) | Yes | The expenditure organization incurring the charge |
| INVOICE_ID | NUMBER | (15) | Yes | The identifier of the invoice |
| VENDOR_ID | NUMBER | (15) | The identifier of the vendor | |
| PROJECT_ID | NUMBER | (15) | Yes | The identifier of the project |
| TASK_ID | NUMBER | (15) | Yes | The identifier of the lowest level task |
| EXPENDITURE_ORGANIZATION_ID | NUMBER | (15) | Yes | 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) | Yes | 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 |
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
FROM APPS.PA_PROJ_AP_INV_DISTRIBUTIONS;
APPS
AP_INVOICES_ALL
AP_INVOICES_PKG
- show dependent code
AP_INVOICE_DISTRIBUTIONS_ALL
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
PO_DISTRIBUTIONS_ALL
PO_VENDORS
APPS
GMS_COMMITMENTS_OVERRIDE_V
GMS_PA_API3
- show dependent code
PA_CHECK_COMMITMENTS
- show dependent code
PA_COMMITMENTS_V
PA_COMMITMENT_TXNS_V
PA_PROJ_COMMITMENT_BASE_VIEW
|
|
|
|