PA Push Order

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Concurrent Program to generate XML for Order details to push to G-Invoice System
Application: Projects
Source: MGT:Push Order
Short Name: PAGOPUSH_XML
DB package: PA_PAGOPUSH_XMLP_PKG
Run PA Push Order and other Oracle EBS reports with Blitz Report™ on our demo environment
  SELECT 
       order_id 
       ,order_line_id	   order_line_id1 
       ,order_line_schedule_id  order_line_schedule_id1       
       ,req_activity_id           
       ,req_agency_acc_id         
       ,req_agency_disburse_id    
       ,req_budget_line_item      
       ,req_cost_center_id        
       ,req_cost_element          
       ,req_functional_area       
       ,req_fund_center_id        
       ,req_project_id            
       ,req_reimburse_flag_id     
       ,req_sec_coop              
       ,req_sec_coop_case_desig   
       ,req_sec_coop_line_id      
       ,req_sec_coop_imp_agncy    
       ,req_sub_allocation        
       ,req_work_order_no         
       ,req_fiscal_year           
       ,req_activity_add_code     
       ,req_activity_class_ref_id 
       ,req_ship_to_title         
       ,req_ship_to_add1          
       ,req_ship_to_add2          
       ,req_ship_to_add3          
       ,req_ship_to_add_id        
       ,req_ship_to_city          
       ,req_ship_to_contact       
       ,req_ship_to_country       
       ,req_ship_to_email         
       ,req_ship_to_name          
       ,req_ship_to_phone         
       ,req_ship_to_post_code     
       ,req_ship_to_loc           
       ,req_ship_to_instr         
       ,req_ship_to_state         
       ,req_add_acc_info          
       ,req_add_info              
       ,req_agency_id             
       ,req_alloc_trans_ag_id     
       ,req_avail_type            
       ,req_beg_period_avail      
       ,req_busines_event_type    
       ,req_bpn_plus4_no          
       ,req_end_period_avail      
       ,req_main_acc_code         
       ,req_obj_class_code        
       ,req_ps_bonafide_desc      
       ,req_sub_acc_code          
       ,req_sub_level_prefix      
       ,req_piid                  
       ,req_parent_award_id       
       ,req_federal_award_id      
       ,req_unique_record_id      
       ,serv_activity_id          
       ,serv_agency_acc_id        
       ,serv_agency_disburse_id   
       ,serv_budget_line_item     
       ,serv_cost_center_id       
       ,serv_cost_element         
       ,serv_functional_area      
       ,serv_fund_center_id       
       ,serv_project_id           
       ,serv_reimburse_flag_id    
       ,serv_sec_coop             
       ,serv_sec_coop_case_desig  
       ,serv_sec_coop_line_id     
       ,serv_sec_coop_imp_agncy   
       ,serv_sub_allocation       
       ,serv_work_order_no        
       ,serv_fiscal_year          
       ,serv_activity_add_code    
       ,serv_activity_class_ref_id
       ,serv_add_acc_info         
       ,serv_add_info             
       ,serv_agency_id            
       ,serv_alloc_trans_ag_id    
       ,serv_avail_type           
       ,serv_beg_period_avail     
       ,serv_busines_event_type   
       ,serv_bpn_plus4_no         
       ,serv_end_period_avail     
       ,serv_main_acc_code        
       ,serv_obj_class_code       
       ,serv_ps_bonafide_desc     
       ,serv_sub_acc_code         
       ,serv_sub_level_prefix     
       ,serv_piid                 
       ,serv_parent_award_id      
       ,serv_federal_award_id     
       ,serv_unique_record_id     
       ,schedule_num              
       ,schedule_status_code      
       ,quantity                  
       ,unit_price                
       ,advance_indicator         
   FROM PA_IGT_ORDER_LINE_SHED_UDA_GTT
  WHERE ORDER_ID = :p3_order_id
    AND ORDER_LINE_ID =  :p3_order_line_id
	AND ORDER_LINE_SCHEDULE_ID = :P3_order_line_schedule_id
  order by order_line_id , order_line_schedule_id
Parameter Name SQL text Validation
Operating Unit
 
LOV
Order Number
 
Char
Blitz Report™