Load all Dropdown details in Master Data - MOT Approver Interface

Note: All dropdowns will have an item "ALL"

1/ ID = hidden
2/ ApproverName = show | dropdown with search functionality inside access_usr, type at least 3 characters
3/ ApproverNTID = hidden | populated and saved from ApproverName
4/ Designation = show | dropdown (Manager, Senior Manager, Director, Senior Director)
5/ Level = show | dropdown (L1, L2, L3)
6/ CostLowerThreshold = Free-type positive integer - hidden
7/ CostUpperThreshold = Free-type positive integer - hidden
8/ ThresholdDescription = Free text - hidden
9/ BU = show| dropdown (select LOB from dbo.imp_BOBJ_APO_Master_Data nolock WHERE lob is not null Group by LOB)
10/ BrandLevel = show | dropdown (select [Brand Level] from dbo.imp_BOBJ_APO_Master_Data nolock WHERE [Brand Level] is not null Group by [Brand Level])

<DELETED - START>
11/ Shipping Location = show | dropdown with search | (select [Manufacturing Location Text] location UNION select nodal_location)
12/ Shipping Location Description = Show | on the fly populated description
13/ Destination Location = show | dropdown with search | (select destinationlocation from flex_routing)
14/ Destination location description = Show | on the fly populated description

<DELETED - END>
15/ MOT = Show | dropdown (AIR, OCEAN, ROAD, ROAD OCEAN)
16/ Forwarder = show | dropdown (select from forwarder table)

<ADD - START>

17/ Shipping Country =  show | dropdown with search | (Select Countries corresponding to the locations from (select [Manufacturing Location Text] location UNION select nodal_location))

18/ Destination Country =  show | dropdown with search | Select Countries corresponding to the locations from (select destinationlocation from flex_routing))

<ADD - END>