PO Printed Planning Schedule

Description
Categories: BI Publisher
Columns: Schedule Id, Schedule Num, Schedule Type, Type, Status, Horizon Start, Horizon End, Bucket, Rev, Mrp Plan ...
Application: Purchasing
Source: Printed Planning Schedule (XML)
Short Name: CHVPRSCH_XML
DB package: PO_CHVPRSCH_XMLP_PKG
select
csh.schedule_id,
csh.schedule_num,
csh.schedule_type ,
polc1.displayed_field Type,
polc2.displayed_field Status,
csh.schedule_horizon_start Horizon_Start,
csh.schedule_horizon_end Horizon_End,
cbp.bucket_pattern_name Bucket,
csh.schedule_revision Rev,
csh.mrp_compile_designator MRP_Plan,
csh.mps_schedule_designator MSP_Plan,
csh.drp_compile_designator DRP_Plan,
pov.vendor_name Supplier,
povs.vendor_site_code Site,
povs.address_line1 A1ddress,
povs.address_line2 A2ddress,
povs.address_line3 A3ddress,
povs.city||', '||
povs.state||' '