sSQL statement (1): SELECT id_itm, [cost_center_no], [mon_open], [mon_close], [tues_open], [tues_close], [weds_open], [weds_close], [thurs_open], [thurs_close], [fri_open], [fri_close], [sat_open], [sat_close], [sun_open], [sun_close], [stat_flg], [no_days_open], [cc_name], [cc_desc], [regular_whse_1], [PHONE_NUMBER], [FAX_NUMBER], [EMAIL], [ADD_1], [ADD_2], [ADD_3], [cc_city_st_add], [zip_code], [zip4], [COUNTY], [county_name], [STORE_FORMAT], [str_sls_des], [square_feet], [flr_sls_area], [supr_dist], [REGION], [MGR_NAME], [bal] FROM [erp_rms_13].[dbo].[vw_itminv] where (id_itm = 06822) and (store_format in (1,2,6,7)) ORDER BY county_name, str_sls_des, cost_center_no ASC

strInvTotal 1 = -1

Store Inventory
There were NO Locations
found for your selected search criteria of:
State Wide ALL
  • Code: 6822
  • Description: Item not available
  • Size:
  • Price: $0.00
Page 1 of 1


Disclaimer: Store inventory is accurate as of the close of the previous business day. Please call the store for the most current availability.

Close this Page to Return to Product List  ||  Return to Address Categories

There are no records found for this search.

Privacy Policy | Security Policy

Copyright ©2015 Pennsylvania Liquor Control Board. All Rights Reserved.