INV Shortage Parameter
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Shortage Parameter report
Application: Inventory
Source: Shortage Parameter report (XML)
Short Name: INVSRSPT_XML
DB package: INV_INVSRSPT_XMLP_PKG
Description: Shortage Parameter report
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' |