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
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