[Home] [Help] [Dependency Information]
Object Name: | PJM_PROJECT_ONHAND_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PJM.PJM_PROJECT_ONHAND_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
PJM_PROJECT_ONHAND_V returns inventory onhand quantity information for each project.
This view corresponds to the Onhand Balances web inquiry region.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | System-generated number that uniquely identifies a project or seiban | |
TASK_ID | NUMBER | (15) | System-generated number that uniquely identifies a task | |
ORGANIZATION_ID | NUMBER | Yes | Inventory organization unique identifier | |
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Inventory organization name |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item unique identifier | |
ITEM | VARCHAR2 | (40) | Item number | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
SUBINVENTORY | VARCHAR2 | (10) | Yes | Subinventory |
LOCATOR | CHAR | (1) | Stock locator | |
PRIMARY_UOM | VARCHAR2 | (3) | Primary unit of measure of item | |
TOTAL_ONHAND_QUANTITY | NUMBER | Total onhand quantity in this stock location. Stock location includes subinventory and locator. |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, TASK_ID
, ORGANIZATION_ID
, ORGANIZATION_NAME
, INVENTORY_ITEM_ID
, ITEM
, ITEM_DESCRIPTION
, SUBINVENTORY
, LOCATOR
, PRIMARY_UOM
, TOTAL_ONHAND_QUANTITY
FROM APPS.PJM_PROJECT_ONHAND_V;
APPS.PJM_PROJECT_ONHAND_V is not referenced by any database object
|
|
|