INV Shortage Parameter

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Shortage Parameter report (XML)
Short Name: INVSRSPT_XML
DB package: INV_INVSRSPT_XMLP_PKG
select 	PAR.ORGANIZATION_CODE||'   '||ORG.NAME  ORG_NAME, 
	sp.organization_id,
	m1.meaning  CHECK_OE_FLAG, 
	m2.meaning  CHECK_WIP_FLAG,
	m3.meaning WIP_REL_JOBS_FLAG, 
	sp.WIP_DAYS_OVERDUE_REL_JOBS, 
	m4.meaning WIP_UNREL_JOBS_FLAG, 
	sp.WIP_DAYS_OVERDUE_UNREL_JOBS, 
	m5.meaning  WIP_HOLD_JOBS_FLAG,
	m6.meaning WIP_REL_REP_FLAG, 
	sp.WIP_DAYS_OVERDUE_REL_REP, 
	m7.meaning WIP_UNREL_REP_FLAG, 
	sp.WIP_DAYS_OVERDUE_UNREL_REP, 
	m8.meaning WIP_HOLD_REP_FLAG,
	m9.meaning WIP_REQ_DATE_JOBS_FLAG, 
	m10.meaning  WIP_CURR_OP_JOBS_FLAG, 
	m11.meaning WIP_PREV_OP_JOBS_FLAG,
	m12.meaning WIP_REQ_DATE_REP_FLAG,
	m13.meaning  WIP_CURR_OP_REP_FLAG, 
	m14.meaning  WIP_PREV_OP_REP_FLAG,  
	m15.meaning  WIP_EXCL_BULK_COMP_FLAG, 
	m16.meaning  WIP_EXCL_SUPPLIER_COMP_FLAG, 
	m17.meaning  WIP_EXCL_PULL_COMP_FLAG,  
	m18.meaning  WIP_NOTIF_ASS_PLANNER_FLAG, 
	m19.meaning WIP_NOTIF_COMP_BUYER_FLAG, 
	m20.meaning WIP_NOTIF_COMP_PLANNER_FLAG, 
	m21.meaning WIP_NOTIF_JOB_CREATOR_FLAG, 
	m22.meaning  OE_NOTIF_ITEM_PLANNER_FLAG, 
	m23.meaning  OE_NOTIF_SO_CREATOR_FLAG
from 	MTL_SHORT_CHK_PARAM sp,
      	HR_ORGANIZATION_UNITS ORG,
 	MTL_PARAMETERS PAR,
       	MFG_LOOKUPS m1,
       	MFG_LOOKUPS m2,         
       	MFG_LOOKUPS m3,         
	MFG_LOOKUPS m4,        
	MFG_LOOKUPS m5,        
	MFG_LOOKUPS m6,        
	MFG_LOOKUPS m7,  
	MFG_LOOKUPS m8,
	MFG_LOOKUPS m9,
	MFG_LOOKUPS m10,
	MFG_LOOKUPS m11,
	MFG_LOOKUPS m12,
	MFG_LOOKUPS m13,
	MFG_LOOKUPS m14,
	MFG_LOOKUPS m15,
	MFG_LOOKUPS m16,
	MFG_LOOKUPS m17,
	MFG_LOOKUPS m18,
	MFG_LOOKUPS m19,
	MFG_LOOKUPS m20,
	MFG_LOOKUPS m21,
	MFG_LOOKUPS m22,
	MFG_LOOKUPS m23
where 	sp.organization_id =:P_ORGANIZATION_ID
	and sp.organization_id = org.organization_id
	and org.organization_id = par.organization_id
	and m1.lookup_code = sp.CHECK_OE_FLAG
	and m1.lookup_type = 'SYS_YES_NO'
	and m2.lookup_code = sp.CHECK_WIP_FLAG
	and m2.lookup_type = 'SYS_YES_NO'
	and m3.lookup_code = sp.WIP_REL_JOBS_FLAG
	and m3.lookup_type = 'SYS_YES_NO'
	and m4.lookup_code = sp.WIP_UNREL_JOBS_FLAG 
	and m4.lookup_type = 'SYS_YES_NO'
	and m5.lookup_code = sp.WIP_HOLD_JOBS_FLAG
	and m5.lookup_type = 'SYS_YES_NO'
	and m6.lookup_code = sp.WIP_REL_REP_FLAG 
	and m6.lookup_type = 'SYS_YES_NO'
	and m7.lookup_code = sp.WIP_UNREL_REP_FLAG 
	and m7.lookup_type = 'SYS_YES_NO'
	and m8.lookup_code = sp.WIP_HOLD_REP_FLAG 
	and m8.lookup_type = 'SYS_YES_NO'
	and m9.lookup_code = sp.WIP_REQ_DATE_JOBS_FLAG
	and m9.lookup_type = 'SYS_YES_NO'
	and m10.lookup_code = sp.WIP_CURR_OP_JOBS_FLAG
	and m10.lookup_type = 'SYS_YES_NO'
	and m11.lookup_code = sp.WIP_PREV_OP_JOBS_FLAG
	and m11.lookup_type = 'SYS_YES_NO'
	and m12.lookup_code = sp.WIP_REQ_DATE_REP_FLAG 
	and m12.lookup_type = 'SYS_YES_NO'
	and m13.lookup_code = sp.WIP_CURR_OP_REP_FLAG 
	and m13.lookup_type = 'SYS_YES_NO'
	and m14.lookup_code = sp.WIP_PREV_OP_REP_FLAG 
	and m14.lookup_type = 'SYS_YES_NO'
	and m15.lookup_code = sp.WIP_EXCL_BULK_COMP_FLAG
	and m15.lookup_type = 'SYS_YES_NO'
	and m16.lookup_code = sp.WIP_EXCL_SUPPLIER_COMP_FLAG
	and m16.lookup_type = 'SYS_YES_NO'
	and m17.lookup_code = sp.WIP_EXCL_PULL_COMP_FLAG 
	and m17.lookup_type = 'SYS_YES_NO'
	and m18.lookup_code = sp.WIP_NOTIF_ASS_PLANNER_FLAG
	and m18.lookup_type = 'SYS_YES_NO'
	and m19.lookup_code = sp.WIP_NOTIF_COMP_BUYER_FLAG
	and m19.lookup_type = 'SYS_YES_NO'
	and m20.lookup_code = sp.WIP_NOTIF_COMP_PLANNER_FLAG
	and m20.lookup_type = 'SYS_YES_NO'
	and m21.lookup_code = sp.WIP_NOTIF_JOB_CREATOR_FLAG 
	and m21.lookup_type = 'SYS_YES_NO'
	and m22.lookup_code = sp.OE_NOTIF_ITEM_PLANNER_FLAG
	and m22.lookup_type = 'SYS_YES_NO'
	and m23.lookup_code = sp.OE_NOTIF_SO_CREATOR_FLAG
	and m23.lookup_type = 'SYS_YES_NO'
Parameter Name SQL text Validation
Organization
 
Number
Ask a question