RLM Demand Status Inquiry

➜ Back to Library
Description
Categories: BI Publisher
Application: Release Management
Source: Demand Status Inquiry Report (XML)
Short Name: RLMDMQRY_XML
DB package: RLM_RLMDMSIQ_XMLP_PKG
Run RLM Demand Status Inquiry and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Title 
 
 Char
Ship From 
 
 LOV Oracle
Customer Name 
 
 LOV Oracle
Ship To 
 
 LOV Oracle
Intermediate Ship To 
 
 LOV Oracle
From Order 
 
 LOV Oracle
To Order 
 
 LOV Oracle
From Requirement Date 
 
 DateTime
To Requirement Date 
 
 DateTime
(C)ustomer or (I)nventory Item 
 
 LOV Oracle
From Item 
 
 LOV Oracle
To Item 
 
 LOV Oracle
Requirements (F)irm, F(O)recast, (B)oth 
 
 LOV Oracle
(S)hipped, (U)nshipped or (B)oth 
 
 LOV Oracle
Include Canceled Lines (y/n) 
 
 LOV Oracle
Summarize by Date and Bucket (y/n) 
 
 LOV Oracle
Include Curr Resource Authorizations (y/n) 
 
 LOV Oracle
Download
Related Blitz Reports
RLM Release Management Purge Schedule Exception RLM Release Management Exceptions RLM Compare Schedule To Demand ECC Project Manufacturing, Sales Orders ECC Project Manufacturing Genealogy & Trace, Sales Orders ECC Project Manufacturing, Exceptions and Overdues, SQL4 ECC Project Manufacturing, Exceptions and Overdues, SQL3 ONT - Planning Reliability Metric GL Account Analysis
Blitz Report™

Blitz Report™ provides multiple benefits: