ENG Engineering Change Order Approval Lists

Description
Categories: BI Publisher, Manufacturing
Application: Engineering
Source: Engineering Change Order Approval Lists Report (XML)
Short Name: ENGRCOAL_XML
DB package: ENG_ENGRCOAL_XMLP_PKG
select
                  al.approval_list_name,
                  al.disable_date disable_date,
                  al.description description,
                  a.sequence1,
                  e.full_name,
                  a.description description1,
                  a.disable_date disable_date1
            from  eng_ecn_approval_lists al,
                  eng_ecn_approvers a,
                  mtl_employees_view e
            where a.approval_list_id = al.approval_list_id
            and   e.employee_id = a.employee_id
            and   e.organization_id = :P_org
            and  (:P_NAME_FROM is NULL or
                  ((al.approval_list_name >= :P_NAME_FROM) and
                    (al.approval_list_name <= :P_NAME_TO)))
            order by al.approval_list_name,al.disable_date, al.description,
                     a.sequence1, e.full_name, a.description, a.disable_date
Ask a question
Parameter Name SQL text Validation
Organization_id
 
Number
To
 
LOV Oracle
Approval List Names From
 
LOV Oracle