RLM Demand Status Inquiry

Description
Categories: BI Publisher, Manufacturing
Application: Release Management
Source: Demand Status Inquiry Report (XML)
Short Name: RLMDMQRY_XML
DB package: RLM_RLMDMSIQ_XMLP_PKG
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
Parameter Name SQL text Validation
Include Curr Resource Authorizations (y/n)
 
LOV Oracle
Summarize by Date and Bucket (y/n)
 
LOV Oracle
Include Canceled Lines (y/n)
 
LOV Oracle
(S)hipped, (U)nshipped or (B)oth
 
LOV Oracle
Requirements (F)irm, F(O)recast, (B)oth
 
LOV Oracle
To Item
 
LOV Oracle
From Item
 
LOV Oracle
(C)ustomer or (I)nventory Item
 
LOV Oracle
To Requirement Date
 
DateTime
From Requirement Date
 
DateTime
To Order
 
LOV Oracle
From Order
 
LOV Oracle
Intermediate Ship To
 
LOV Oracle
Ship To
 
LOV Oracle
Customer Name
 
LOV Oracle
Ship From
 
LOV Oracle
Title