IGI Secondary Invoice Approval : Flexfield Assignments - draft
Description
Categories: BI Publisher
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
Source: Secondary Invoice Approval : Flexfield Assignments (XML) - Not Supported: Reserved For Future Use
Short Name: IGIPSIAP_XML
DB package: IGI_IGIPSIAP_XMLP_PKG
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 | |
---|---|---|---|
Approval Group | LOV Oracle | ||
Approver | LOV Oracle | ||
Flexfield From | |||
Flexfield To | |||
GL_SRS_NULL_NUM | Number | ||
Chart of Accounts | LOV Oracle |