Answer Happy

List the vendor code, name of the vendor, number of product and
the total holding inventory value that will supply the holding
inventory. The total holding inventory value is the sum of
P_QOH*P_PRICE of the products. Sort the output by the V_CODE in
ascending order. P_QOH= Product Quantity on holding.
CUSTOMER INVOICE LINE PK INV NUMBER 主 contains TAPK PK,FK1 INV NUMBER LINE NUMBER PK CUS CODE HE generates CUS_LNAME CUS_FNAME CUS_INITIAL CUS AREACODE CUS_PHONE CUS_BALANCE FK1 CUS_CODE INV_DATE FK2 P_CODE LINE_UNITS LINE_PRICE is found in PRODUCT VENDOR PK V_CODE PK P CODE V_NAME V_CONTACT HE .- supplies V_AREACODE V_PHONE V_STATE V_ORDER P_DESCRIPT P_INDATE P_QOH P_MIN P_PRICE P_DISCOUNT FK1 V_CODE Cengage Learning © 2015