VIEW: APPS.PMIBV_INV_SUMMARY_V

Source

View Text - Preformatted

SELECT invsum.ONHAND_QTY, /* regular attributes */ invsum.ONHAND_QTY2, invsum.ONHAND_PROD_QTY, invsum.ONHAND_PROD_QTY2, invsum.ONHAND_ORDER_QTY, invsum.ONHAND_ORDER_QTY2, invsum.ONHAND_SHIP_QTY, invsum.ONHAND_SHIP_QTY2, invsum.ONPURCH_QTY, invsum.ONPURCH_QTY2, invsum.ONPROD_QTY, invsum.ONPROD_QTY2, invsum.COMMITTEDSALES_QTY, invsum.COMMITTEDSALES_QTY2, invsum.COMMITTEDPROD_QTY, invsum.COMMITTEDPROD_QTY2, invsum.INTRANSIT_QTY, invsum.INTRANSIT_QTY2, item.ITEM_ID, /* ID */ invsum.WHSE_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, invsum.CREATED_BY, invsum.CREATION_DATE, invsum.LAST_UPDATE_DATE, invsum.LAST_UPDATED_BY from IC_SUMM_INV invsum, IC_ITEM_MST item WHERE item.item_id = invsum.item_id(+) with read only

View Text - HTML Formatted

SELECT INVSUM.ONHAND_QTY
, /* REGULAR ATTRIBUTES */ INVSUM.ONHAND_QTY2
, INVSUM.ONHAND_PROD_QTY
, INVSUM.ONHAND_PROD_QTY2
, INVSUM.ONHAND_ORDER_QTY
, INVSUM.ONHAND_ORDER_QTY2
, INVSUM.ONHAND_SHIP_QTY
, INVSUM.ONHAND_SHIP_QTY2
, INVSUM.ONPURCH_QTY
, INVSUM.ONPURCH_QTY2
, INVSUM.ONPROD_QTY
, INVSUM.ONPROD_QTY2
, INVSUM.COMMITTEDSALES_QTY
, INVSUM.COMMITTEDSALES_QTY2
, INVSUM.COMMITTEDPROD_QTY
, INVSUM.COMMITTEDPROD_QTY2
, INVSUM.INTRANSIT_QTY
, INVSUM.INTRANSIT_QTY2
, ITEM.ITEM_ID
, /* ID */ INVSUM.WHSE_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
, INVSUM.CREATED_BY
, INVSUM.CREATION_DATE
, INVSUM.LAST_UPDATE_DATE
, INVSUM.LAST_UPDATED_BY
FROM IC_SUMM_INV INVSUM
, IC_ITEM_MST ITEM
WHERE ITEM.ITEM_ID = INVSUM.ITEM_ID(+) WITH READ ONLY