You are browsing the archive for Logistics & Warehouse.

Demand Status Inquiry Report (XML)

 

NAME: Demand Status Inquiry Report (XML)
SHORT CODE: RLMDMQRY_XML
MODULE: Oracle Release Management

Description: Demand Status Inquiry Report
Navigation: Oracle Release Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_org_id : Organization ID
  • p_title : Title
  • p_ship_from : Ship From
  • p_customer : Customer Name
  • p_ship_to : Ship To
  • p_deliver_to : Intermediate Ship To
  • p_from_order : From Order Number
  • p_to_order : To Order Number
  • p_from_date : From Requirement Date
  • p_to_date : To Requirement Date
  • p_cust_or_inv_item : (C)ustomer or (I)nventory Item
  • p_from_item : From Item
  • p_to_item : To Item
  • p_req_firm_forecast_both : Requirements (F)irm, F(O)recast, (B)oth
  • p_ship_unship_both : (S)hipped, (U)nshipped or (B)oth
  • p_incl_canceled_lines : Include Canceled Lines (y/n)
  • p_sum_date_and_bucket : Summarize by Date and Bucket (y/n)
  • p_incl_curr_res_authzns : Include Curr Resource Authorizations (y/n)
  • DebugFlag : DebugFlag

 

Demand Status Inquiry Report

 

NAME: Demand Status Inquiry Report
SHORT CODE: RLMDMQRY
MODULE: Oracle Release Management

Description: Demand Status Inquiry Report
Navigation: Oracle Release Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_org_id : Organization ID
  • p_title : Title
  • p_ship_from : Ship From
  • p_customer : Customer Name
  • p_ship_to : Ship To
  • p_deliver_to : Intermediate Ship To
  • p_from_order : From Order Number
  • p_to_order : To Order Number
  • p_from_date : From Requirement Date
  • p_to_date : To Requirement Date
  • p_cust_or_inv_item : (C)ustomer or (I)nventory Item
  • p_from_item : From Item
  • p_to_item : To Item
  • p_req_firm_forecast_both : Requirements (F)irm, F(O)recast, (B)oth
  • p_ship_unship_both : (S)hipped, (U)nshipped or (B)oth
  • p_incl_canceled_lines : Include Canceled Lines (y/n)
  • p_sum_date_and_bucket : Summarize by Date and Bucket (y/n)
  • p_incl_curr_res_authzns : Include Curr Resource Authorizations (y/n)

 

Compare Schedule To Demand Report (XML)

 

NAME: Compare Schedule To Demand Report (XML)
SHORT CODE: RLMDMCOM_XML
MODULE: Oracle Release Management

Description: Compare Schedule To Demand Report
Navigation: Oracle Release Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_org_id : Org Id
  • p_title : Title
  • p_schedule_type : Schedule Type
  • p_schedule_reference_num : Schedule Reference Number
  • p_customer_name_from : Customer Name From
  • p_customer_name_to : Customer Name To
  • p_ship_from : Ship From
  • p_ship_to : Ship to
  • p_issue_date_from : Issue Date From
  • p_issue_date_to : Issue Date To
  • p_request_date_from : Request Date From
  • p_request_date_to : Request Date To
  • p_customer_item_from : Customer Item From
  • p_customer_item_to : Customer Item To
  • p_internal_item_from : Internal Item From
  • p_internal_item_to : Internal Item To
  • p_tp_code_from : TP Code From
  • p_tp_code_to : TP Code To
  • p_tp_location_from : TP Location From
  • p_tp_location_to : TP Location To
  • p_process_date_from : Process Date From
  • p_process_date_to : Process Date To
  • p_seq_match_attribute : Sequence Matching Attrib