pears.NetOwnerCompanySalesStatuses [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== pears.NetOwnerCompanySalesStatuses ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create procedure "pears"."NetOwnerCompanySalesStatuses"( in "pWebUserID" char(20) ) 
result( "CompanySalesStatusID" char(1),"Name" char(40),"SortOrder" integer ) 
begin
  select "CompanySalesStatusID",
    "Name",
    "Sortorder"
    from "CompanySalesStatus"
    order by "SortOrder" asc
end /* DOC
2020-06-01 GJ IW-1188 Created/Modified proc from Justin so it works on the web
*/
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerCompanySalesStatuses" IS 
{create PROCEDURE pears."NetOwnerCompanySalesStatuses"(in pWebUserID char(20))
RESULT (CompanySalesStatusID char(1) ,[Name] char(40) ,SortOrder integer)
BEGIN
    SELECT
        CompanySalesStatusID,
        [Name],
        Sortorder
    FROM
        CompanySalesStatus
    ORDER BY
        SortOrder ASC
END

/* DOC
2020-06-01 GJ IW-1188 Created/Modified proc from Justin so it works on the web
*/
}
</code>