[Home] [Help] [Dependency Information]
Object Name: | PMIFV_PERIODINVENTORY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMIFV_PERIODINVENTORY_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QTY_ONHAND | NUMBER | Period ending balance of lot/item in secondary UOM of an item, for dual UOM items. | ||
QTY_ONHAND_IN_UM2 | NUMBER | Period ending balance of lot/item in primary UOM of an item. | ||
QTY_USED | NUMBER | Consumption of the item in production during the period, in the primary inventory UOM of an item. | ||
QTY_USED_IN_UM2 | NUMBER | Consumption of the item in production during the period, in the secondary inventory UOM of an item, for dual UOM items. | ||
YIELD | NUMBER | Yield of the item from production during the period, in the primary inventory UOM of an item. | ||
YIELD_IN_UM2 | NUMBER | Yield of the item from production during the period, in the secondary inventory UOM of an item, for dual UOM items. | ||
VALUE | NUMBER | Value of loct_usage. Equals loct_usage*accounting cost. | ||
LAST_PERIOD_CLOSE_DATE | DATE | Last time Inventory Close was run. | ||
WAREHOUSE_CODE | VARCHAR2 | (4) | Warehouse which contains the item balances. | |
LOT_ID | NUMBER | (10) | Surrogate key for the lot/sublot. 0 identifies the default lot. LOT_ID is set to '0' for items without lot control. | |
LOCATION | VARCHAR2 | (16) | Location in the warehouse, if any, which contains the balance. | |
ITEM_ID | NUMBER | (10) | Surrogate key for the item. | |
LOT_STATUS | VARCHAR2 | (4) | Status of the lot. | |
QC_HOLD_REASON_CODE | VARCHAR2 | (4) | Reason code associated with the lot status. | |
PERIOD_ID | NUMBER | (10) | Surrogate key of the period. | |
FISCAL_YEAR | VARCHAR2 | (4) | Name of the inventory calendar. | |
CALENDER_DESCRIPTION | VARCHAR2 | (40) | Cost Calendar Description | |
PERIOD_DESCRIPTION | VARCHAR2 | (40) | Cost Period Description | |
PERIOD | NUMBER | (5) | Inventory period for which the balance is stored. | |
ITEM_NUMBER | VARCHAR2 | (32) | Name of the item. | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Short description of the item that is displayed during the item look up. | |
ITEM_UOM | VARCHAR2 | (4) | Uom of the item by which the inventory balances are maintained. | |
ITEM_UOM2 | VARCHAR2 | (4) | Second UOM for in which inventory balances are maintained, for dual UOM items. | |
LOT_NUMBER | VARCHAR2 | (32) | Code for the lot. | |
SUBLOT_NUMBER | VARCHAR2 | (32) | Code for the sublot. | |
QC_GRADE | VARCHAR2 | (4) | QC grade of the lot. | |
LOT_EXPIRE_DATE | DATE | Lot expiration date. | ||
LOT_CREATION_DATE | DATE | Standard who column | ||
VENDOR_LOT_NUMBER | VARCHAR2 | (32) | Vendor lot number. | |
WAREHOUSE_NAME | VARCHAR2 | (40) | Name of the warehouse. | |
ORGANIZATION_CODE | VARCHAR2 | (4) | Organization that owns the warehouse. | |
CO_CODE | VARCHAR2 | (4) | Company code of the organization. | |
LOCATION_DESCRIPTION | VARCHAR2 | (40) | Description of the location. | |
LOCATION_CAPACITY | NUMBER | Capacity of the location. | ||
CAPACITY_UM | VARCHAR2 | (4) | Unit of measure in which the capacity is expressed. | |
STATUS_DESCRIPTION | VARCHAR2 | (40) | Description of status. | |
QCHOLD_REASON_DESCRIPTION | VARCHAR2 | (80) | Description of the QC hold reason. | |
PERIOD_START_DATE | DATE | Cost Period Start Date | ||
PERIOD_END_DATE | DATE | Cost Period End Date | ||
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
PERIOD_STATUS | NUMBER | '0=frozen', 1= open' | ||
PERIOD_STATUS_MEANING | VARCHAR2 | (10) | meaning of period status column |
Cut, paste (and edit) the following text to query this object:
SELECT QTY_ONHAND
, QTY_ONHAND_IN_UM2
, QTY_USED
, QTY_USED_IN_UM2
, YIELD
, YIELD_IN_UM2
, VALUE
, LAST_PERIOD_CLOSE_DATE
, WAREHOUSE_CODE
, LOT_ID
, LOCATION
, ITEM_ID
, LOT_STATUS
, QC_HOLD_REASON_CODE
, PERIOD_ID
, FISCAL_YEAR
, CALENDER_DESCRIPTION
, PERIOD_DESCRIPTION
, PERIOD
, ITEM_NUMBER
, ITEM_DESCRIPTION
, ITEM_UOM
, ITEM_UOM2
, LOT_NUMBER
, SUBLOT_NUMBER
, QC_GRADE
, LOT_EXPIRE_DATE
, LOT_CREATION_DATE
, VENDOR_LOT_NUMBER
, WAREHOUSE_NAME
, ORGANIZATION_CODE
, CO_CODE
, LOCATION_DESCRIPTION
, LOCATION_CAPACITY
, CAPACITY_UM
, STATUS_DESCRIPTION
, QCHOLD_REASON_DESCRIPTION
, PERIOD_START_DATE
, PERIOD_END_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, PERIOD_STATUS
, PERIOD_STATUS_MEANING
FROM APPS.PMIFV_PERIODINVENTORY_V;
APPS.PMIFV_PERIODINVENTORY_V is not referenced by any database object
|
|
|