INV Material Status Where-Used

Description

Categories: BI Publisher, Logistics

Application: Inventory
Source: Material Status Where-Used Report (XML)
Short Name: INVMSWHU_XML
DB package: INV_INVMSWHU_XMLP_PKG

Copy

SELECT	MS.STATUS_ID	STATUS_ID
  ,	MS.STATUS_CODE	STATUS_CODE
  ,	MS.DESCRIPTION	MS_DESCRIPTION
  ,	MFG1.MEANING	MS_ZONE_CONTROL
  ,	MFG2.MEANING	MS_LOCATOR_CONTROL
  ,	MFG3.MEANING	MS_LOT_CONTROL
  ,	MFG4.MEANING	MS_SERIAL_CONTROL
  ,	MFG5.MEANING	MS_ENABLED_FLAG
FROM	MTL_MATERIAL_STATUSES_VL MS
  ,	MFG_LOOKUPS MFG1
  ,	MFG_LOOKUPS MFG2
  ,	MFG_LOOKUPS MFG3
  ,	MFG_LOOKUPS MFG4
  ,	MFG_LOOKUPS MFG5
WHERE	MS.STATUS_CODE BETWEEN :P_MS_LO AND :P_MS_HI 
AND	(	MFG1.LOOKUP_TYPE = 'SYS_YES_NO'
	 AND	MFG1.LOOKUP_CODE = NVL(MS.ZONE_CONTROL,2))
AND	(	MFG2.LOOKUP_TYPE = 'SYS_YES_NO'
	 AND	MFG2.LOOKUP_CODE = NVL(MS.LOCATOR_CONTROL,2))
AND	( 	MFG3.LOOKUP_TYPE = 'SYS_YES_NO'
	 AND	MFG3.LOOKUP_CODE = NVL(MS.LOT_CONTROL,2))
AND	(	MFG4.LOOKUP_TYPE = 'SYS_YES_NO'
	 AND	MFG4.LOOKUP_CODE = NVL(MS.SERIAL_CONTROL,2))
AND	(	MFG5.LOOKUP_TYPE = 'SYS_YES_NO'
	 AND	MFG5.LOOKUP_CODE = NVL(MS.ENABLED_FLAG,2))
ORDER BY MS.STATUS_CODE

Parameter Name

SQL text

Validation

Search in Serials

LOV Oracle

Search in Lots

LOV Oracle

Search in Locators

LOV Oracle

Search in Subinventories

LOV Oracle

Material Status To

LOV Oracle

Material Status From

LOV Oracle

Organization

LOV Oracle

Download

Related Blitz Reports

INV Material Status Change History CST Inventory Subledger (1) CST Inventory Value Report - by Cost Group CST Inventory Value Report - by Subinventory INV Cycle count listing (1) INV Item-subinventory INV Cycle count listing CST Inventory Subledger CSE Bill of Lading