PO IGT Order Data Template

Description
Categories: BI Publisher
Imported from BI Publisher
Application: Purchasing
Source:
Short Name: PO_IGT_ORDER
DB package:
Run PO IGT Order Data Template and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT pol.po_line_id
      		               ,pol.line_location_id
      		               ,pol.po_distribution_id
      		               ,ext_table_alias.n_ext_attr1 ag_acc_id
      		               ,ext_table_alias.c_ext_attr2 ac_add_code
                           ,ext_table_alias.c_ext_attr3 act_id
                           ,ext_table_alias.c_ext_attr4 fiscal_year
                           ,ext_table_alias.c_ext_attr5 bud_lin_item
                           ,ext_table_alias.c_ext_attr6 cost_center_id
                           ,ext_table_alias.c_ext_attr7 cost_element
                           ,ext_table_alias.c_ext_attr8 fed_award_id
                           ,ext_table_alias.c_ext_attr9 func_area
                           ,ext_table_alias.c_ext_attr10 fund_cen_id
                           ,ext_table_alias.c_ext_attr11 reimburse_flag
                           ,ext_table_alias.c_ext_attr12 sec_coop_case
                           ,ext_table_alias.c_ext_attr13 sec_coop
                           ,ext_table_alias.c_ext_attr14 sec_coop_line
                           ,ext_table_alias.c_ext_attr15 sec_coop_imp
                           ,ext_table_alias.c_ext_attr16 sub_alloc
                           ,ext_table_alias.c_ext_attr17 uri
                           ,ext_table_alias.c_ext_attr18 work_ord_no
                           ,ext_table_alias.c_ext_attr19 parent_awd_id
                           ,ext_table_alias.c_ext_attr20 piid
                     FROM    po_distributions_all_ext_vl ext_table_alias, PO_DISTRIBUTIONS_MERGE_V pol, ego_attr_groups_v ego
                     WHERE   ext_table_alias.attr_group_id = ego.ATTR_GROUP_ID
                     AND     ego.ATTR_GROUP_NAME = 'IGT_REQ_ACC'
                     AND     ego.ATTR_GROUP_TYPE = 'PO_DISTRIBUTIONS_EXT_ATTRS'
                     AND     ext_table_alias.po_distribution_id = pol.po_distribution_id
                     AND     ext_table_alias.draft_id = pol.draft_id
                     AND     pol.po_header_id = :PoHeaderId
                     AND     pol.draft_id = :DraftId
Blitz Report™