VIEW: APPS.PMIFV_INV_SUMMARY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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