IGI Secondary Invoice Approval : Flexfield Assignments- Not Supported: Reserved For Future Use

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Secondary Invoice Approval : Flexfield Assignments
Application: Public Sector Financials International
Source: Secondary Invoice Approval : Flexfield Assignments (XML) - Not Supported: Reserved For Future Use
Short Name: IGIPSIAP_XML
DB package: IGI_IGIPSIAP_XMLP_PKG
Run IGI Secondary Invoice Approval : Flexfield Assignments- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT        g.group_name,
        f.user_name,
        emp.full_name,
        d.start_date_active,
        d.end_date_active,
        d.approver_id,
        g.group_id
FROM    igi_sap_group g,
        igi_sap_department_approvers d,
        fnd_user f,
        hr_employees emp
WHERE   g.group_id = d.group_id
AND     g.group_id = nvl(:p_approval_group,g.group_id)
AND     f.user_id = d.approver_id
AND     d.approver_id = nvl(:p_approver,d.approver_id)
AND     f.employee_id = emp.employee_id (+)
AND     exists
        (select 1
        from     igi_sap_app_ranges p1
                where  p1.approver_id = d.approver_id
        and      p1.group_id = g.group_id
        and     &P_WHERES)         
order   by 1,2
Parameter Name SQL text Validation
Operating Unit
 
LOV
Approval Group
 
LOV Oracle
Approver
 
LOV Oracle
Flexfield From
 
Char
Flexfield To
 
Char