VIEW: APPS.PMIFV_CURRENTINVENTORY_V

Source

View Text - Preformatted

SELECT inv.LOCT_ONHAND, inv.LOCT_ONHAND2, inv.WHSE_CODE, lot.LOT_ID, inv.LOCATION, lot.ITEM_ID, inv.LOT_STATUS, inv.QCHOLD_RES_CODE, item.item_no, item.item_desc1, item.item_um, item.item_um2, lot.lot_no, lot.sublot_no, lot.qc_grade, lot.expire_date, lot.creation_date, lot.vendor_lot_no , warehouse.WHSE_NAME, warehouse.ORGN_CODE, sy.CO_CODE, location.LOCT_DESC, location.CAPACITY, location.CAPACITY_UM, lot_stat.STATUS_DESC, QChold_reason.QCHOLD_RES_DESC, inv.LAST_UPDATED_BY, inv.CREATED_BY, inv.LAST_UPDATE_DATE, inv.CREATION_DATE FROM ic_loct_inv inv, ic_item_mst item, ic_lots_mst lot, ic_whse_mst warehouse, ic_loct_mst location, ic_lots_sts lot_stat, gmd_hold_reasons_vl QChold_reason, sy_orgn_mst sy WHERE inv.item_id(+) = lot.item_id and inv.lot_id (+) = lot.lot_id and lot.item_id = item.item_id and inv.whse_code = warehouse.whse_code(+) and warehouse.orgn_code = sy.orgn_code and inv.whse_code = location.whse_code(+) and inv.location = location.location(+) and inv.lot_status = lot_stat.lot_status (+) and inv.qchold_res_code = QChold_reason.qchold_res_code(+) and (inv.delete_mark = 0 OR inv.delete_mark IS NULL) and (warehouse.orgn_code is NULL or warehouse.orgn_code IN (SELECT secorg.orgn_code FROM sy_orgn_mst secorg WHERE PMI_SECURITY_PKG.show_record(secorg.orgn_code) = 'TRUE')) with read only

View Text - HTML Formatted

SELECT INV.LOCT_ONHAND
, INV.LOCT_ONHAND2
, INV.WHSE_CODE
, LOT.LOT_ID
, INV.LOCATION
, LOT.ITEM_ID
, INV.LOT_STATUS
, INV.QCHOLD_RES_CODE
, ITEM.ITEM_NO
, ITEM.ITEM_DESC1
, ITEM.ITEM_UM
, ITEM.ITEM_UM2
, LOT.LOT_NO
, LOT.SUBLOT_NO
, LOT.QC_GRADE
, LOT.EXPIRE_DATE
, LOT.CREATION_DATE
, LOT.VENDOR_LOT_NO
, WAREHOUSE.WHSE_NAME
, WAREHOUSE.ORGN_CODE
, SY.CO_CODE
, LOCATION.LOCT_DESC
, LOCATION.CAPACITY
, LOCATION.CAPACITY_UM
, LOT_STAT.STATUS_DESC
, QCHOLD_REASON.QCHOLD_RES_DESC
, INV.LAST_UPDATED_BY
, INV.CREATED_BY
, INV.LAST_UPDATE_DATE
, INV.CREATION_DATE
FROM IC_LOCT_INV INV
, IC_ITEM_MST ITEM
, IC_LOTS_MST LOT
, IC_WHSE_MST WAREHOUSE
, IC_LOCT_MST LOCATION
, IC_LOTS_STS LOT_STAT
, GMD_HOLD_REASONS_VL QCHOLD_REASON
, SY_ORGN_MST SY
WHERE INV.ITEM_ID(+) = LOT.ITEM_ID
AND INV.LOT_ID (+) = LOT.LOT_ID
AND LOT.ITEM_ID = ITEM.ITEM_ID
AND INV.WHSE_CODE = WAREHOUSE.WHSE_CODE(+)
AND WAREHOUSE.ORGN_CODE = SY.ORGN_CODE
AND INV.WHSE_CODE = LOCATION.WHSE_CODE(+)
AND INV.LOCATION = LOCATION.LOCATION(+)
AND INV.LOT_STATUS = LOT_STAT.LOT_STATUS (+)
AND INV.QCHOLD_RES_CODE = QCHOLD_REASON.QCHOLD_RES_CODE(+)
AND (INV.DELETE_MARK = 0 OR INV.DELETE_MARK IS NULL)
AND (WAREHOUSE.ORGN_CODE IS NULL OR WAREHOUSE.ORGN_CODE IN (SELECT SECORG.ORGN_CODE
FROM SY_ORGN_MST SECORG
WHERE PMI_SECURITY_PKG.SHOW_RECORD(SECORG.ORGN_CODE) = 'TRUE')) WITH READ ONLY