VIEW: APPS.PMIBV_CURRENTINVENTORY_V

Source

View Text - Preformatted

SELECT inv.LOCT_ONHAND, /* regular attributes */ inv.LOCT_ONHAND2, inv.WHSE_CODE, /* ID */ LOT.LOT_ID, inv.LOCATION, LOT.ITEM_ID, inv.LOT_STATUS, inv.QCHOLD_RES_CODE, lot.lot_no, lot.sublot_no, lot.qc_grade, lot.expire_date, lot.creation_date, lot.vendor_lot_no , inv.LAST_UPDATED_BY, /* WHO */ inv.CREATED_BY, inv.LAST_UPDATE_DATE, inv.CREATION_DATE FROM ic_loct_inv inv, ic_lots_mst lot WHERE inv.lot_id(+) = lot.lot_id AND inv.item_id(+) = lot.item_id AND (inv.delete_mark = 0 OR inv.delete_mark IS NULL) with read only

View Text - HTML Formatted

SELECT INV.LOCT_ONHAND
, /* REGULAR ATTRIBUTES */ INV.LOCT_ONHAND2
, INV.WHSE_CODE
, /* ID */ LOT.LOT_ID
, INV.LOCATION
, LOT.ITEM_ID
, INV.LOT_STATUS
, INV.QCHOLD_RES_CODE
, LOT.LOT_NO
, LOT.SUBLOT_NO
, LOT.QC_GRADE
, LOT.EXPIRE_DATE
, LOT.CREATION_DATE
, LOT.VENDOR_LOT_NO
, INV.LAST_UPDATED_BY
, /* WHO */ INV.CREATED_BY
, INV.LAST_UPDATE_DATE
, INV.CREATION_DATE
FROM IC_LOCT_INV INV
, IC_LOTS_MST LOT
WHERE INV.LOT_ID(+) = LOT.LOT_ID
AND INV.ITEM_ID(+) = LOT.ITEM_ID
AND (INV.DELETE_MARK = 0 OR INV.DELETE_MARK IS NULL) WITH READ ONLY