INV Planner listing

➜ Back to Library
XLSExcel example XMLXML import file

Description

Categories
BI Publisher
Application
Inventory
Source
Planner listing (XML)
Short Name
INVSRPLN_XML
DB package
INV_INVSRPLN_XMLP_PKG
Imported from BI Publisher
Planner listing

SQL 10 lines

SELECT 
        PLANNER_CODE       PLAN_CODE, 
        DESCRIPTION            DESCRIPTION, 
        DISABLE_DATE          DISABLE_DATE
FROM  
       MTL_PLANNERS 
WHERE 
      ORGANIZATION_ID = :P_ORGANIZATION_ID 
ORDER BY PLANNER_CODE