VK Test - Open Orders

Description
Venkat Test Report
select oh.order_number,
        oh.ordered_date,
        hca.account_number customer_number,
        oh.flow_status_code header_status_code,
        ol.line_number || '.' || ol.shipment_number line_number,
        ol.ordered_item,
        ol.flow_status_code line_status_code
from
  oe_order_headers_all   oh,
  oe_order_lines_all  ol,
  hz_cust_accounts hca
where 
1=1 
and oh.header_id = ol.header_id
and oh.sold_to_org_id = hca.cust_Account_id
and oh.open_flag = 'Y'
and oh.flow_status_code <> 'CANCELLED'
and ol.flow_status_code <> 'CANCELLED'
and oh.ordered_date > trunc(sysdate, 'YYYY')
--and oh.ordered_date > sysdate-:p_nbr_of_days
Parameter Name SQL text Validation
Order Number
oh.order_number = :p_order_number
LOV