PA Push Order
Description
- Categories
- BI Publisher
- Application
- Projects
- Source
- MGT:Push Order
- Short Name
- PAGOPUSH_XML
- DB package
- PA_PAGOPUSH_XMLP_PKG
Imported from BI Publisher
Concurrent Program to generate XML for Order details to push to G-Invoice System
Concurrent Program to generate XML for Order details to push to G-Invoice System
SQL 104 lines
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 |
Parameters 2
| Parameter | Type | List of values SQL |
|---|---|---|
| Operating Unit | LOV | |
| Order Number | Char |