eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PMIBV_PERIODINVENTORY_V

Product:	PMI - Process Manufacturing Intelligence
Description:	Qty and usage info for Items in Inv. for closed periods by whse, location, lot and item, unioned with Current inv. in the open period.
Implementation/DBA Data:	APPS.PMIBV_PERIODINVENTORY_V

View Text

SELECT INV.LOCT_ONHAND
, /* REGULAR ATTRIBUTES */ INV.LOCT_ONHAND2
, INV.LOCT_USAGE
, INV.LOCT_USAGE2
, INV.LOCT_YIELD
, INV.LOCT_YIELD2
, INV.LOCT_VALUE
, INV.LOG_END_DATE
, INV.WHSE_CODE
, /* ID */ INV.LOT_ID
, INV.LOCATION
, INV.ITEM_ID
, INV.LOT_STATUS
, INV.QCHOLD_RES_CODE
, INV.PERIOD_ID
, INV.FISCAL_YEAR
, INV.PERIOD
, INV.LAST_UPDATED_BY
, /* WHO COLUMNS */ INV.CREATED_BY
, INV.LAST_UPDATE_DATE
, INV.CREATION_DATE
FROM IC_PERD_BAL INV WITH READ ONLY

Columns

Name
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
PERIOD
LAST_UPDATED_BY
CREATED_BY
LAST_UPDATE_DATE
CREATION_DATE