[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PJM_PO_COMMITMENTS_CMPRJ_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PJM.PJM_PO_COMMITMENTS_CMPRJ_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
PJM_PO_COMMITMENTS_CMPRJ_V returns project-related purchase order distributions in Oracle Purchasing which have a destination of Inventory or Shop Floor and have not yet been received.
Most of the project information required by Oracle Projects are derived using the following algorithm:
- If a project is directly referenced on the purchase order distribution, it will be used; otherwise, if the destination organization is associated with a common project in the Project Manufacturing organization setup, the common project will be used.
- If Task AutoAssignment is implemented, task is derived from the predefined assignment rules if a task is not directly referenced on the purchase order distribution.
- Expenditure item date is derived from the first available value need-by date, promised date and creation date of the shipment line, in that order.
- The destination organization is used as the expenditure organization if the destination is inventory, otherwise the expenditure organization will be derived from the BOM department of the receiving routing operation if the destination is shop floor.
- Expenditure type is derived from the expenditure type associated with the first material sub-element of the item.
.
Because of differences in Task AutoAssignment attributes, this view is split into two UNION sections, one part for inventory destination purchase order distributions and the other part for shop floor destination purchase order distributions.
.
This view is used by the Oracle Projects Commitments module.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PO_NUMBER | VARCHAR2 | (20) | Yes | Purchase order number |
| PO_REVISION | NUMBER | Purchase order revision | ||
| RELEASE_NUMBER | NUMBER | Purchase release number | ||
| RELEASE_REVISION | NUMBER | Purchase release revision | ||
| APPROVED_FLAG | VARCHAR2 | (1) | Flag indicating purchase order is approved | |
| EVER_APPROVED_FLAG | VARCHAR2 | (1) | Flag indicating whether purchase order has ever been approved | |
| DOCUMENT_TYPE | VARCHAR2 | (4000) | Procurement document type | |
| CREATION_DATE | DATE | Standard Who column | ||
| APPROVED_DATE | DATE | Date purchase order is approved | ||
| PRINTED_DATE | DATE | Date purchase order is printed | ||
| REQUESTOR_PERSON_ID | NUMBER | (9) | Requestor unique identifier | |
| REQUESTOR_NAME | VARCHAR2 | (4000) | Requestor name | |
| BUYER_PERSON_ID | NUMBER | (9) | Yes | Buyer employee unique identifier |
| BUYER_NAME | VARCHAR2 | (4000) | Buyer employee name | |
| VENDOR_NAME | VARCHAR2 | (4000) | Supplier name | |
| VENDOR_ID | NUMBER | Supplier unique identifier | ||
| PO_LINE | NUMBER | Yes | Purchase order line | |
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
| UNIT | VARCHAR2 | (4000) | Unit of measure | |
| UNIT_PRICE | NUMBER | Cost per unit of the project-related commitment distribution | ||
| DENOM_CURRENCY_CODE | VARCHAR2 | (15) | Transaction currency code | |
| ACCT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Functional currency code |
| ACCT_RATE_DATE | DATE | Functional currency exchange rate date | ||
| ACCT_RATE_TYPE | VARCHAR2 | (30) | Functional currency exchange rate type | |
| ACCT_EXCHANGE_RATE | NUMBER | Exchange rate to functional currency | ||
| QUANTITY_ORDERED | NUMBER | Distribution quantity ordered for this purchase order commitment | ||
| AMOUNT_ORDERED | NUMBER | Distribution amount ordered for this purchase order commitment | ||
| ORIGINAL_QUANTITY_ORDERED | NUMBER | Distribution original quantity ordered for this purchase order commitment | ||
| ORIGINAL_AMOUNT_ORDERED | NUMBER | Distribution original amount ordered for this purchase order commitment | ||
| QUANTITY_CANCELLED | NUMBER | Distribution quantity cancelled on this purchase order commitment | ||
| AMOUNT_CANCELLED | NUMBER | Distribution amount cancelled on this purchase order commitment | ||
| QUANTITY_DELIVERED | NUMBER | Distribution quantity delivered for this purchase order commitment | ||
| DENOM_AMOUNT_DELIVERED | NUMBER | Distribution amount delivered in purchase order currency for this purchase order commitment | ||
| AMOUNT_DELIVERED | NUMBER | Distribution amount delivered in functional currency for this purchase order commitment | ||
| QUANTITY_INVOICED | NUMBER | Distribution quantity invoiced for this purchase order commitment | ||
| AMOUNT_INVOICED | NUMBER | Distribution amount invoiced for this purchase order commitment | ||
| QUANTITY_OUTSTANDING_DELIVERY | NUMBER | Distribution quantity outstanding delivery for this purchase order commitment | ||
| DENOM_AMT_OUTSTANDING_DELIVERY | NUMBER | Distribution amount outstanding delivery in purchase order currency for this purchase order commitment | ||
| AMOUNT_OUTSTANDING_DELIVERY | NUMBER | Distribution amount outstanding delivery for this purchase order commitment | ||
| QUANTITY_OUTSTANDING_INVOICE | NUMBER | Distribution quantity outstanding invoice for this purchase order commitment | ||
| DENOM_AMT_OUTSTANDING_INVOICE | NUMBER | Distribution amount outstanding invoice in purchase order currency for this purchase order commitment | ||
| AMOUNT_OUTSTANDING_INVOICE | NUMBER | Distribution amount outstanding invoice for this purchase order commitment | ||
| QUANTITY_OVERBILLED | NUMBER | Distribution quantity overbilled for this purchase order commitment | ||
| AMOUNT_OVERBILLED | NUMBER | Distribution amount overbilled for this purchase order commitment | ||
| PROJECT_NUMBER | VARCHAR2 | (25) | Yes | User-entered number that uniquely identifies a project or seiban |
| PROJECT_NAME | VARCHAR2 | (30) | Yes | User-entered project / seiban name |
| TASK_NUMBER | VARCHAR2 | (25) | Yes | User-entered string that uniquely identifies a task within a project |
| TASK_NAME | VARCHAR2 | (20) | Yes | User-entered task name |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Yes | Commitment expenditure type |
| EXPENDITURE_CATEGORY | VARCHAR2 | (30) | Yes | Expenditure category of the commitment |
| REVENUE_CATEGORY | VARCHAR2 | (30) | Yes | Revenue category of the commitment |
| EXPENDITURE_ITEM_DATE | DATE | Date on which you expect to incur the commitment costs | ||
| EXPENDITURE_ORGANIZATION | VARCHAR2 | (240) | Yes | Expenditure organization incurring the commitment |
| PO_HEADER_ID | NUMBER | Yes | Purchase order header unique identifier | |
| PO_RELEASE_ID | NUMBER | Blanket purchase release unique identifier | ||
| PO_LINE_ID | NUMBER | Yes | Purchase order line unique identifier | |
| PO_LINE_LOCATION_ID | NUMBER | Yes | Purchase order line shipment unique identifier | |
| PO_DISTRIBUTION_ID | NUMBER | Yes | Purchase order distribution unique identifier | |
| PROJECT_ID | NUMBER | (15) | Yes | System-generated number that uniquely identifies a project or seiban |
| TASK_ID | NUMBER | (15) | Yes | Task unique identifier |
| EXPENDITURE_ORGANIZATION_ID | NUMBER | (15) | Yes | Unique identifier of the expenditure organization incurring the commitment |
| PROMISED_DATE | DATE | Purchase order promised date | ||
| NEED_BY_DATE | DATE | Purchase order need-by date | ||
| INVENTORY_ITEM_ID | NUMBER | Inventory item unique identifier | ||
| INVENTORY_ITEM_NAME | VARCHAR2 | (4000) | Item name | |
| WIP_RESOURCE_ID | NUMBER | Resource unique identifier | ||
| WIP_RESOURCE_NAME | VARCHAR2 | (4000) | Resource name | |
| UOM_CODE | VARCHAR2 | (4000) | Code for Unit of Measure | |
| UNIT_OF_MEASURE | VARCHAR2 | (4000) | Unit of Measure |
Cut, paste (and edit) the following text to query this object:
SELECT PO_NUMBER
, PO_REVISION
, RELEASE_NUMBER
, RELEASE_REVISION
, APPROVED_FLAG
, EVER_APPROVED_FLAG
, DOCUMENT_TYPE
, CREATION_DATE
, APPROVED_DATE
, PRINTED_DATE
, REQUESTOR_PERSON_ID
, REQUESTOR_NAME
, BUYER_PERSON_ID
, BUYER_NAME
, VENDOR_NAME
, VENDOR_ID
, PO_LINE
, ITEM_DESCRIPTION
, UNIT
, UNIT_PRICE
, DENOM_CURRENCY_CODE
, ACCT_CURRENCY_CODE
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, QUANTITY_ORDERED
, AMOUNT_ORDERED
, ORIGINAL_QUANTITY_ORDERED
, ORIGINAL_AMOUNT_ORDERED
, QUANTITY_CANCELLED
, AMOUNT_CANCELLED
, QUANTITY_DELIVERED
, DENOM_AMOUNT_DELIVERED
, AMOUNT_DELIVERED
, QUANTITY_INVOICED
, AMOUNT_INVOICED
, QUANTITY_OUTSTANDING_DELIVERY
, DENOM_AMT_OUTSTANDING_DELIVERY
, AMOUNT_OUTSTANDING_DELIVERY
, QUANTITY_OUTSTANDING_INVOICE
, DENOM_AMT_OUTSTANDING_INVOICE
, AMOUNT_OUTSTANDING_INVOICE
, QUANTITY_OVERBILLED
, AMOUNT_OVERBILLED
, PROJECT_NUMBER
, PROJECT_NAME
, TASK_NUMBER
, TASK_NAME
, EXPENDITURE_TYPE
, EXPENDITURE_CATEGORY
, REVENUE_CATEGORY
, EXPENDITURE_ITEM_DATE
, EXPENDITURE_ORGANIZATION
, PO_HEADER_ID
, PO_RELEASE_ID
, PO_LINE_ID
, PO_LINE_LOCATION_ID
, PO_DISTRIBUTION_ID
, PROJECT_ID
, TASK_ID
, EXPENDITURE_ORGANIZATION_ID
, PROMISED_DATE
, NEED_BY_DATE
, INVENTORY_ITEM_ID
, INVENTORY_ITEM_NAME
, WIP_RESOURCE_ID
, WIP_RESOURCE_NAME
, UOM_CODE
, UNIT_OF_MEASURE
FROM APPS.PJM_PO_COMMITMENTS_CMPRJ_V;
APPS
GL_SETS_OF_BOOKS
HR_ALL_ORGANIZATION_UNITS_TL
PA_EXPENDITURE_TYPES
PA_PROJECTS_ALL
PA_TASKS
PJM_COMMITMENT_UTILS
- show dependent code
PO_DISTRIBUTIONS_ALL
PO_HEADERS_ALL
PO_LINES_ALL
PO_LINE_LOCATIONS_ALL
PO_RELEASES_ALL
APPS.PJM_PO_COMMITMENTS_CMPRJ_V is not referenced by any database object
|
|
|
|