RLM Demand Status Inquiry

select oelines.sold_to_org_id,
       oelines.ship_to_org_id ship_to_org_id3, 
       nvl(oelines.intmed_ship_to_org_id, -1) intmed_ship_to_org_id, 
       oelines.ship_from_org_id, 
       oelines.inventory_item_id,
       oelines.ordered_item_id,
       &LP_Q1_COL1 requirement_date,
       &LP_Q1_COL2 firm_status,                          
       oelines.demand_bucket_type_code,
       &LP_Q1_COL17 schedule_type,                    
       to_number(&LP_Q1_COL3) order_number,
       to_number(&LP_Q1_COL4) line_number,
       &LP_Q1_COL5 cust_po_number,
       to_number(&LP_Q1_COL6) ordered_quantity,
       &LP_Q1_COL7 order_quantity_uom, 
       to_number(&LP_Q1_COL8) shipped_quantity, 
       &LP_Q1_COL9 shipping_quantity_uom, 
       to_number(&LP_Q1_COL10) fulfilled_quantity,
       &LP_Q1_COL11 fulfilled_quantity_uom, 
       &LP_Q1_COL12 schedule_reference_num,
       &LP_Q1_COL13 customer_job, 
       &LP_Q1_COL14 planning_sequence, 
       &LP_Q1_COL15 cust_model_serial_number, 
       &LP_Q1_COL16 customer_record_year, 
	RLM_RLMDMSIQ_XMLP_PKG.customer_nameformula(oelines.sold_to_org_id) customer_name, 
	RLM_RLMDMSIQ_XMLP_PKG.customer_numberformula(oelines.sold_to_org_id) customer_number, 
	RLM_RLMDMSIQ_XMLP_PKG.intmed_ship_to_locationformul(nvl ( oelines.intmed_ship_to_org_id , - 1 )) intmed_ship_to_location, 
	RLM_RLMDMSIQ_XMLP_PKG.intmed_ship_to_nameformula(nvl ( oelines.intmed_ship_to_org_id , - 1 )) intmed_ship_to_name, 
	RLM_RLMDMSIQ_XMLP_PKG.ship_to_locationformula(oelines.ship_to_org_id) ship_to_location, 
	RLM_RLMDMSIQ_XMLP_PKG.ship_to_nameformula(oelines.ship_to_org_id) ship_to_name, 
	RLM_RLMDMSIQ_XMLP_PKG.ship_from_codeformula(oelines.ship_from_org_id) ship_from_code, 
	RLM_RLMDMSIQ_XMLP_PKG.ship_from_nameformula(oelines.ship_from_org_id) ship_from_name, 
	RLM_RLMDMSIQ_XMLP_PKG.concatenated_segmentsformula(oelines.inventory_item_id, oelines.ship_from_org_id) concatenated_segments, 
	RLM_RLMDMSIQ_XMLP_PKG.descriptionformula(oelines.inventory_item_id, oelines.ship_from_org_id) description, 
	RLM_RLMDMSIQ_XMLP_PKG.customer_item_numberformula(oelines.ordered_item_id) customer_item_number, 
	RLM_RLMDMSIQ_XMLP_PKG.customer_item_descformula(oelines.ordered_item_id) customer_item_desc, 
	RLM_RLMDMSIQ_XMLP_PKG.bucket_type_codeformula(oelines.demand_bucket_type_code) bucket_type_code, 
	RLM_RLMDMSIQ_XMLP_PKG.cf_sched_type(&LP_Q1_COL17) CF_sched_type
from     oe_order_lines_all oelines, 
         oe_order_headers_all oeheaders,
         rlm_schedule_lines_all schlines, 
         rlm_schedule_headers  schheaders
where
oelines.header_id = oeheaders.header_id
and oelines.authorized_to_ship_flag = 'Y'
and oelines.source_document_id = schlines.header_id
and oelines.source_document_line_id = schlines.line_id
and schlines.header_id = schheaders.header_id
and oelines.item_identifier_type = 'CUST'
and schheaders.org_id = schlines.org_id	
and schheaders.org_id = oeheaders.org_id 	
and schheaders.org_id = oelines.org_id
&LP_Q1_LINES
&P_WHERE_CLAUSE1
&P_WHERE_CLAUSE2
&LP_Q1_GROUP_BY
ORDER BY 1 ASC,3 ASC,2 ASC,4 ASC,6 ASC,5 ASC