Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
---|---|
Description: | This View finds the Inv. balance by item/Whse/Grade. |
Implementation/DBA Data: | APPS.PMIFV_INV_SUMMARY_V |
SELECT INVSUM.ONHAND_QTY
, NVL(INVSUM.ONHAND_QTY2
, 0)
, INVSUM.ONHAND_PROD_QTY
, NVL(INVSUM.ONHAND_PROD_QTY2
, 0)
, INVSUM.ONHAND_ORDER_QTY
, NVL(INVSUM.ONHAND_ORDER_QTY2
, 0)
, INVSUM.ONHAND_SHIP_QTY
, NVL(INVSUM.ONHAND_SHIP_QTY2
, 0)
, INVSUM.ONPURCH_QTY
, NVL(INVSUM.ONPURCH_QTY2
, 0)
, INVSUM.ONPROD_QTY
, NVL(INVSUM.ONPROD_QTY2
, 0)
, INVSUM.COMMITTEDSALES_QTY
, NVL(INVSUM.COMMITTEDSALES_QTY2
, 0)
, INVSUM.COMMITTEDPROD_QTY
, NVL(INVSUM.COMMITTEDPROD_QTY2
, 0)
, INVSUM.INTRANSIT_QTY
, NVL(INVSUM.INTRANSIT_QTY2
, 0)
, ITEM.ITEM_ID
, INVSUM.WHSE_CODE
, SY.ORGN_CODE
, SY.CO_CODE
, INVSUM.QC_GRADE
, ITEM.ITEM_NO
, ITEM.ITEM_DESC1
, ITEM.ALT_ITEMA
, ITEM.ALT_ITEMB
, ITEM.ITEM_UM
, ITEM.ITEM_UM2
, ITEM.PLANNING_CLASS
, WHSE.WHSE_NAME
, QCGRADE.QC_GRADE_DESC
, ITEM.CREATED_BY
, ITEM.CREATION_DATE
, ITEM.LAST_UPDATE_DATE
, ITEM.LAST_UPDATED_BY
FROM IC_SUMM_INV INVSUM
, IC_ITEM_MST ITEM
, IC_WHSE_MST WHSE
, GMD_GRADES_VL QCGRADE
, SY_ORGN_MST SY
WHERE ITEM.ITEM_ID = INVSUM.ITEM_ID(+)
AND INVSUM.WHSE_CODE = WHSE.WHSE_CODE(+)
AND INVSUM.QC_GRADE = QCGRADE.QC_GRADE(+)
AND WHSE.ORGN_CODE = SY.ORGN_CODE(+)
AND (WHSE.ORGN_CODE IS NULL OR WHSE.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