[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PJM_REQ_COMMITMENTS_BASIC_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PJM.PJM_REQ_COMMITMENTS_BASIC_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
PJM_REQ_COMMITMENTS_BASIC_V returns project-related requisition distributions in Oracle Purchasing with a destination of Inventory or Shop Floor that have not yet been purchased on a purchase order.
This view is similar to PJM_REQ_COMMITMENTS_CMPRJ_V, but has been simplified by removing common project logic for better performance.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REQ_NUMBER | VARCHAR2 | (20) | Yes | Purchase requisition number |
| DOCUMENT_TYPE | VARCHAR2 | (4000) | Procurement document type | |
| APPROVED_FLAG | VARCHAR2 | (1) | Flag indicating purchase requisition is approved | |
| REQ_LINE | NUMBER | Yes | Requisition line number | |
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Yes | Item description |
| NEED_BY_DATE | DATE | Purchase requisition need-by date | ||
| CREATION_DATE | DATE | Date purchase requisition created | ||
| VENDOR_NAME | VARCHAR2 | (240) | Supplier name | |
| VENDOR_ID | NUMBER | Supplier unique identifier | ||
| REQUESTOR_PERSON_ID | NUMBER | (9) | Yes | Requestor unique identifier |
| REQUESTOR_NAME | VARCHAR2 | (4000) | Requestor name | |
| DENOM_CURRENCY_CODE | VARCHAR2 | (15) | Transaction currency code | |
| DENOM_AMOUNT | NUMBER | Requisition amount in purchase requisition currency | ||
| 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 | ||
| UNIT | VARCHAR2 | (4000) | Unit of measure | |
| UNIT_PRICE | NUMBER | Cost per unit of the project-related commitment distribution | ||
| QUANTITY | NUMBER | Quantity requested | ||
| AMOUNT | NUMBER | Requisition amount in functional currency | ||
| 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 |
| REQUISITION_HEADER_ID | NUMBER | Yes | Purchase requisition header unique identifier | |
| REQUISITION_LINE_ID | NUMBER | Yes | Purchase requisition line unique identifier | |
| REQ_DISTRIBUTION_ID | NUMBER | Yes | Purchase requisition 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 |
| 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 REQ_NUMBER
, DOCUMENT_TYPE
, APPROVED_FLAG
, REQ_LINE
, ITEM_DESCRIPTION
, NEED_BY_DATE
, CREATION_DATE
, VENDOR_NAME
, VENDOR_ID
, REQUESTOR_PERSON_ID
, REQUESTOR_NAME
, DENOM_CURRENCY_CODE
, DENOM_AMOUNT
, ACCT_CURRENCY_CODE
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, UNIT
, UNIT_PRICE
, QUANTITY
, AMOUNT
, PROJECT_NUMBER
, PROJECT_NAME
, TASK_NUMBER
, TASK_NAME
, EXPENDITURE_TYPE
, EXPENDITURE_CATEGORY
, REVENUE_CATEGORY
, EXPENDITURE_ITEM_DATE
, EXPENDITURE_ORGANIZATION
, REQUISITION_HEADER_ID
, REQUISITION_LINE_ID
, REQ_DISTRIBUTION_ID
, PROJECT_ID
, TASK_ID
, EXPENDITURE_ORGANIZATION_ID
, INVENTORY_ITEM_ID
, INVENTORY_ITEM_NAME
, WIP_RESOURCE_ID
, WIP_RESOURCE_NAME
, UOM_CODE
, UNIT_OF_MEASURE
FROM APPS.PJM_REQ_COMMITMENTS_BASIC_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_REQUISITION_HEADERS_ALL
PO_REQUISITION_LINES_ALL
PO_REQ_DISTRIBUTIONS_ALL
APPS.PJM_REQ_COMMITMENTS_BASIC_V is not referenced by any database object
|
|
|
|