eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PMIFV_PERIODINVENTORY_V

Source

View Text - Preformatted


SELECT inv.LOCT_ONHAND, inv.LOCT_ONHAND2 , inv.LOCT_USAGE, inv.LOCT_USAGE2, inv.LOCT_YIELD, inv.LOCT_YIELD2, inv.LOCT_VALUE, inv.LOG_END_DATE, inv.WHSE_CODE, lot.LOT_ID, inv.LOCATION , lot.ITEM_ID, inv.LOT_STATUS , inv.QCHOLD_RES_CODE , inv.PERIOD_ID, inv.FISCAL_YEAR, periods.CALENDAR_DESC, periods.PERIOD_DESC, inv.PERIOD, 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, periods.start_date, periods.end_date, lot.CREATED_BY, lot.CREATION_DATE, lot.LAST_UPDATED_BY, lot.LAST_UPDATE_DATE, 1, substr(pmi_cost_analz_pack.gmca_get_meaning('PERIOD_STATUS', 1),1,10) FROM ic_perd_bal 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, pmi_inv_calendar_v periods, 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.period_id = periods.period_id 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')) union all select loctinv.LOCT_ONHAND, loctinv.LOCT_ONHAND2 , 0, 0, 0, 0, 0, sysdate, loctinv.WHSE_CODE, lot.LOT_ID, loctinv.LOCATION , lot.ITEM_ID, loctinv.LOT_STATUS , loctinv.QCHOLD_RES_CODE , periods.period_id, periods.fiscal_year, periods.CALENDAR_DESC, periods.PERIOD_DESC, periods.PERIOD, 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, orgnmst.co_code, location.LOCT_DESC, location.CAPACITY, location.CAPACITY_UM, lot_stat.STATUS_DESC, QChold_reason. QCHOLD_RES_DESC, periods.start_date, periods.end_date, lot.CREATED_BY, lot.CREATION_DATE, lot.LAST_UPDATED_BY, lot.LAST_UPDATE_DATE, 0, substr(pmi_cost_analz_pack.gmca_get_meaning('PERIOD_STATUS', 0),1,10) FROM ic_loct_inv loctinv, 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 orgnmst, pmi_inv_calendar_v periods WHERE lot.item_id = loctinv.item_id(+) and lot.lot_id = loctinv.lot_id(+) and lot.item_id = item.item_id and loctinv.whse_code = warehouse.whse_code(+) and loctinv.whse_code = location.whse_code(+) and loctinv.location = location.location(+) and loctinv.lot_status = lot_stat.lot_status(+) and loctinv.qchold_res_code = QChold_reason.qchold_res_code(+) and warehouse.orgn_code = orgnmst.orgn_code and orgnmst.co_code = periods.orgn_code and trunc(sysdate) between trunc(periods.start_date) and trunc(periods.end_date) 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.LOCT_USAGE
, INV.LOCT_USAGE2
, INV.LOCT_YIELD
, INV.LOCT_YIELD2
, INV.LOCT_VALUE
, INV.LOG_END_DATE
, INV.WHSE_CODE
, LOT.LOT_ID
, INV.LOCATION
, LOT.ITEM_ID
, INV.LOT_STATUS
, INV.QCHOLD_RES_CODE
, INV.PERIOD_ID
, INV.FISCAL_YEAR
, PERIODS.CALENDAR_DESC
, PERIODS.PERIOD_DESC
, INV.PERIOD
, 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
, PERIODS.START_DATE
, PERIODS.END_DATE
, LOT.CREATED_BY
, LOT.CREATION_DATE
, LOT.LAST_UPDATED_BY
, LOT.LAST_UPDATE_DATE
, 1
, SUBSTR(PMI_COST_ANALZ_PACK.GMCA_GET_MEANING('PERIOD_STATUS'
, 1)
, 1
, 10)
FROM IC_PERD_BAL 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
, PMI_INV_CALENDAR_V PERIODS
, 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.PERIOD_ID = PERIODS.PERIOD_ID
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')) UNION ALL SELECT LOCTINV.LOCT_ONHAND
, LOCTINV.LOCT_ONHAND2
, 0
, 0
, 0
, 0
, 0
, SYSDATE
, LOCTINV.WHSE_CODE
, LOT.LOT_ID
, LOCTINV.LOCATION
, LOT.ITEM_ID
, LOCTINV.LOT_STATUS
, LOCTINV.QCHOLD_RES_CODE
, PERIODS.PERIOD_ID
, PERIODS.FISCAL_YEAR
, PERIODS.CALENDAR_DESC
, PERIODS.PERIOD_DESC
, PERIODS.PERIOD
, 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
, ORGNMST.CO_CODE
, LOCATION.LOCT_DESC
, LOCATION.CAPACITY
, LOCATION.CAPACITY_UM
, LOT_STAT.STATUS_DESC
, QCHOLD_REASON. QCHOLD_RES_DESC
, PERIODS.START_DATE
, PERIODS.END_DATE
, LOT.CREATED_BY
, LOT.CREATION_DATE
, LOT.LAST_UPDATED_BY
, LOT.LAST_UPDATE_DATE
, 0
, SUBSTR(PMI_COST_ANALZ_PACK.GMCA_GET_MEANING('PERIOD_STATUS'
, 0)
, 1
, 10)
FROM IC_LOCT_INV LOCTINV
, 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 ORGNMST
, PMI_INV_CALENDAR_V PERIODS
WHERE LOT.ITEM_ID = LOCTINV.ITEM_ID(+)
AND LOT.LOT_ID = LOCTINV.LOT_ID(+)
AND LOT.ITEM_ID = ITEM.ITEM_ID
AND LOCTINV.WHSE_CODE = WAREHOUSE.WHSE_CODE(+)
AND LOCTINV.WHSE_CODE = LOCATION.WHSE_CODE(+)
AND LOCTINV.LOCATION = LOCATION.LOCATION(+)
AND LOCTINV.LOT_STATUS = LOT_STAT.LOT_STATUS(+)
AND LOCTINV.QCHOLD_RES_CODE = QCHOLD_REASON.QCHOLD_RES_CODE(+)
AND WAREHOUSE.ORGN_CODE = ORGNMST.ORGN_CODE
AND ORGNMST.CO_CODE = PERIODS.ORGN_CODE
AND TRUNC(SYSDATE) BETWEEN TRUNC(PERIODS.START_DATE)
AND TRUNC(PERIODS.END_DATE)
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